Received: from crusher.wdsec.com ([206.215.34.17]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAOEkGA42532 for ; Fri, 24 Nov 2000 09:46:17 -0500 (EST) (envelope-from serge@ephilosopher.com) Received: from landru.wdnis ([192.157.171.30]) by crusher.wdsec.com (8.9.3/8.9.3) with ESMTP id JAA20309; Fri, 24 Nov 2000 09:46:17 -0500 (EST) Received: from ephilosopher.com (crusher [206.215.34.17]) by landru.wdnis (8.8.8+Sun/8.8.8) with ESMTP id JAA16544; Fri, 24 Nov 2000 09:46:15 -0500 (EST) Message-ID: <3A1E7F2F.2D9E1E60@ephilosopher.com> Date: Fri, 24 Nov 2000 09:46:07 -0500 From: Serge Canizares X-Mailer: Mozilla 4.72 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Yves Martin , SQL Subject: Re: Statement too long References: <3A0AD389.647EE03A@agliodbs.com> <200011150953.EAA01528@jupiter.jw.home> <20001117105859.A9780@lerami.lerctr.org> <00112316394802.00799@pcyma.elca.ch> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/220 X-Sequence-Number: 251 You probably have PostgreSQL compiled with the default blocksize, which is 8k. OpenACS.org has a nice set of instructions explaining how to increase the size to 16k or 32k. http://openacs.org/doc/openacs/html/simple-pg-install-2.html#ss2.2 Hope that helps. Yves Martin wrote: > Hello, > > I have some problem with too long statement. > In 'psql', the error returned for my insert statement is > ERROR: Tuple is too big: size 10436 > > In fact, I use JDBC driver to insert a long long string into a 'text' > field. The exception is