Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5QE3Ia67739 for ; Tue, 26 Jun 2001 10:03:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 15EtRs-0002oy-0V; Tue, 26 Jun 2001 15:04:13 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id A04DB13C41; Tue, 26 Jun 2001 14:35:00 +0100 (BST) Message-ID: <007701c0fe44$cbe09c20$1001a8c0@archonet.com> From: "Richard Huxton" To: "Antti Linno" , References: Subject: Re: TEXT field size Date: Tue, 26 Jun 2001 14:34:58 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/415 X-Sequence-Number: 3712 From: "Antti Linno" > Hallo. > > Maybe its not the right list, but does the Postgres 7.1 support now > unlimited text field? In previous versions it was limited to max 31k, or > even less, depending on the compilation etc. Yes - look for details of TOAST in the docs. Text fields can be effectively unlimited and IIRC might even get compressed if circumstances look good. There were some issues with old clients (ODBC/JDBC etc) not knowing this and enforcing the old 8KB rule but I think they're probably updated now. - Richard Huxton