pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Statement too long
2+ messages / 2 participants
[nested] [flat]

* Statement too long
@ 2000-11-23 15:34 Yves Martin <yma@elca.ch>
  2000-11-24 14:46 ` Re: Statement too long Serge Canizares <serge@ephilosopher.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Yves Martin @ 2000-11-23 15:34 UTC (permalink / raw)
  To: pgsql-sql


	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

The SQL Statement is too long - INSERT INTO TRIGGERQUEUE       (DUETIME,
TYPE, EVENT, ACTION) VALUES( 974992122555, 'CONTAINER', 
.....(long really long).......

  So is it possible to re-build postmaster to avoid this limitation for
  too long statement or is there another way in JDBC ?

  Another problem is that with jdbc 6.5 and 7.0 the example of using largeobject
  in postgreSQL development corner site does not work. It returns an exception:
  setBinaryStream does not support an input as an InputStream.
  So how to make this exemple work ?

 Regards
  
-- 
Yves Martin
yma, Lausanne




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Statement too long
  2000-11-23 15:34 Statement too long Yves Martin <yma@elca.ch>
@ 2000-11-24 14:46 ` Serge Canizares <serge@ephilosopher.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Serge Canizares @ 2000-11-24 14:46 UTC (permalink / raw)
  To: Yves Martin <yma@elca.ch>; 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-11-24 14:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-23 15:34 Statement too long Yves Martin <yma@elca.ch>
2000-11-24 14:46 ` Serge Canizares <serge@ephilosopher.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox