pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedStatement too long
2+ messages / 2 participants
[nested] [flat]
* Statement too long
@ 2000-11-23 15:34 Yves Martin <yma@elca.ch>
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-24 14:46 Serge Canizares <serge@ephilosopher.com>
parent: Yves Martin <yma@elca.ch>
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