Statement too long

Поиск
Список
Период
Сортировка
От Yves Martin
Тема Statement too long
Дата
Msg-id 00112316394802.00799@pcyma.elca.ch
обсуждение исходный текст
Ответ на Re: Requests for Development  (Larry Rosenman <ler@lerctr.org>)
Список 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
doesnot work. It returns an exception: setBinaryStream does not support an input as an InputStream. So how to make this
exemplework ?
 
Regards 
-- 
Yves Martin
yma, Lausanne



В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruno Boettcher
Дата:
Сообщение: is there a debian package for plperl?
Следующее
От: "Rob Burne"
Дата:
Сообщение: Help with displaying data types.