| From: | Serge Canizares <serge(at)ephilosopher(dot)com> |
|---|---|
| To: | Yves Martin <yma(at)elca(dot)ch>, SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Statement too long |
| Date: | 2000-11-24 14:46:07 |
| Message-ID: | 3A1E7F2F.2D9E1E60@ephilosopher.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-11-24 16:04:56 | Re: pgaccess |
| Previous Message | hubert depesz lubaczewski | 2000-11-24 14:43:07 | Re: create snapshot? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Phillips | 2000-11-24 16:50:31 | Re: psql question |
| Previous Message | Richard DeVenezia | 2000-11-24 14:24:19 | Is there a string to inet function that can be used in order by ? |