Re: Statement too long
Serge Canizares <serge@ephilosopher.com>
From: Serge Canizares <serge@ephilosopher.com>
To: Yves Martin <yma@elca.ch>, SQL <pgsql-sql@postgresql.org>
Date: 2000-11-24T14:46:07Z
Lists: pgsql-general, pgsql-sql
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