X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0491E52FC4 for ; Tue, 26 Jul 2005 04:55:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33902-09 for ; Tue, 26 Jul 2005 07:55:45 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 1933752F3D for ; Tue, 26 Jul 2005 04:55:43 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 80DDA1522C; Tue, 26 Jul 2005 02:55:43 -0500 (CDT) Date: Tue, 26 Jul 2005 02:55:43 -0500 From: "Jim C. Nasby" To: Peter Eisentraut Cc: Bianca Oberst , pgsql-admin@postgresql.org Subject: Re: Size of Large objects Message-ID: <20050726075543.GN29346@decibel.org> References: <3853.1122359862@www10.gmx.net> <200507260947.33721.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200507260947.33721.peter_e@gmx.net> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/201 X-Sequence-Number: 18257 On Tue, Jul 26, 2005 at 09:47:33AM +0200, Peter Eisentraut wrote: > Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst: > > I'm new in postgres. I searched the archives, but I don't find an answer. > > So can anybody tell me the explicit size, which a clob or a blob can have > > in postgres 8.0? > > Columns can contain up to 1 GB of data. The terms clob or blob are not used > in PostgreSQL; the limitation is the same on all column types. Not entirely true... decibel=# select version(); PostgreSQL 8.0.3 on powerpc-apple-darwin7.9.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495) decibel=# create table t(v varchar(1000000000)); ERROR: length for type varchar cannot exceed 10485760 decibel=# -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"