Received: from elca.ch (mail.elca.ch [194.191.157.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eANFcIA61490 for ; Thu, 23 Nov 2000 10:38:19 -0500 (EST) (envelope-from yma@elca.ch) Received: from exchange.elca.ch by elca.ch (8.8.8/SMI-SVR4) id QAA07792; Thu, 23 Nov 2000 16:31:48 +0100 (MET) Received: from pcyma.elca.ch ([10.10.10.112]) by exchange.elca.ch with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id W5DQLCAA; Thu, 23 Nov 2000 16:38:54 +0100 From: Yves Martin Organization: ELCA To: sqllist Subject: Statement too long Date: Thu, 23 Nov 2000 16:34:33 +0100 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain References: <3A0AD389.647EE03A@agliodbs.com> <200011150953.EAA01528@jupiter.jw.home> <20001117105859.A9780@lerami.lerctr.org> In-Reply-To: <20001117105859.A9780@lerami.lerctr.org> MIME-Version: 1.0 Message-Id: <00112316394802.00799@pcyma.elca.ch> Content-Transfer-Encoding: 8bit X-Archive-Number: 200011/194 X-Sequence-Number: 225 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