Re: Statement too long - Mailing list pgsql-sql

From Serge Canizares
Subject Re: Statement too long
Date
Msg-id 3A1E7F2F.2D9E1E60@ephilosopher.com
Whole thread Raw
In response to Requests for Development  (Josh Berkus <josh@agliodbs.com>)
List 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



pgsql-sql by date:

Previous
From: "Richard DeVenezia"
Date:
Subject: Is there a string to inet function that can be used in order by ?
Next
From: Adrian Phillips
Date:
Subject: Re: psql question