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 D0FA952EBA for ; Tue, 26 Jul 2005 10:18:57 -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 04407-10 for ; Tue, 26 Jul 2005 13:18:51 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4DC9252ECC for ; Tue, 26 Jul 2005 10:18:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6QDIpIR026938; Tue, 26 Jul 2005 09:18:51 -0400 (EDT) To: Peter Eisentraut Cc: "Jim C. Nasby" , Bianca Oberst , pgsql-admin@postgresql.org Subject: Re: Size of Large objects In-reply-to: <200507261142.48769.peter_e@gmx.net> References: <3853.1122359862@www10.gmx.net> <200507260947.33721.peter_e@gmx.net> <20050726075543.GN29346@decibel.org> <200507261142.48769.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Tue, 26 Jul 2005 11:42:48 +0200" Date: Tue, 26 Jul 2005 09:18:51 -0400 Message-ID: <26937.1122383931@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/204 X-Sequence-Number: 18260 Peter Eisentraut writes: > Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby: >> decibel=# create table t(v varchar(1000000000)); >> ERROR: length for type varchar cannot exceed 10485760 > The length you can declare and the size you can store (if a length declaration > doesn't stop you) are, for various uninteresting reasons, not related. Also, you can just say "varchar" with no specific length limit, which is then more or less equivalent to "text". regards, tom lane