Received: from p1.selectacast.net (p1.selectacast.net [206.41.1.251]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB4KPqG34834 for ; Mon, 4 Dec 2000 15:25:52 -0500 (EST) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id PAA02895; Mon, 4 Dec 2000 15:25:54 -0500 Message-ID: <3A2BFDD2.65D53311@selectacast.net> Date: Mon, 04 Dec 2000 15:25:54 -0500 From: Joseph Shraibman Organization: Xtenit, Inc. http://www.xtenit.com X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: Greg Speegle , "pgsql-interfaces@postgreSQL.org" Subject: Re: JDBC and long TEXT fields References: <200012011652.WAA08483@tcs.com> <012d01c05c66$0108d6f0$c6290218@workhorse> <002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org> <3A29C2F9.3010101@10happythings.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/23 X-Sequence-Number: 360 Greg Speegle wrote: > > There is actually an 8K (or so) limit to text field length. Although I > believe that is going away > soon, if it hasn't already. There is an 8K limit on the size of a tuple, not the text field. You can recompile postgres to make the limit higher, but until 7.1 the limit will not go away. -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com