Received: from ctb-mesg2.saix.net (ctb-mesg2.saix.net [196.25.240.74]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA35961 for ; Sat, 9 Oct 1999 06:11:04 -0400 (EDT) (envelope-from alex001@global.co.za) Received: from heaven.global.co.za (ndf53-06-p137.gt.saix.net) by ctb-mesg2.saix.net (Sun Internet Mail Server sims.3.5.1999.03.02.17.58.p5) with SMTP id <0FJB00I6BYWZGJ@ctb-mesg2.saix.net> for pgsql-sql@postgresql.org; Sat, 9 Oct 1999 12:10:13 +0200 (SAT) Date: Sat, 09 Oct 1999 12:15:46 +0200 From: Alexander F Hartner Subject: Insert / Update Statement To: pgsql-sql@postgresql.org Message-id: <000701bf123f$416c00e0$8948ef9b@heaven.global.co.za> MIME-version: 1.0 X-Mailer: Microsoft Outlook Express 4.72.3110.5 Content-type: MULTIPART/ALTERNATIVE; BOUNDARY="Boundary_(ID_JCxJTEYk10quLMdDSLCxYQ)" X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Priority: 3 This is a multi-part message in MIME format. --Boundary_(ID_JCxJTEYk10quLMdDSLCxYQ) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable I am updating my postgres database (Postgres 6.4 on Redhat 6) from a = Windows client using Java and JDBC. Everything works fine, util one = tries to insert large amounts of data into a fields. The error reported = indicated that my SQL statement is to long. I have adjusted my code to = update / insert data into one fields at a time, which resulted in many = update / insert statements, and now I can insert more database, but = still not enough.=20 Is there a way I can configure the maximum lenght of the insert = statement, or that I can insert large amounts of data ? Thanks Alex --Boundary_(ID_JCxJTEYk10quLMdDSLCxYQ) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: quoted-printable
I am updating my postgres database (Postgres 6.4 on Redhat 6) from = a=20 Windows client using Java and JDBC. Everything works fine, util one = tries to=20 insert large amounts of data into a fields. The error reported indicated = that my=20 SQL statement is to long. I have adjusted my code to update / insert = data into=20 one fields at a time, which resulted in many update / insert statements, = and now=20 I can insert more database, but still not enough.
 
Is there a way I can configure the maximum lenght of the insert = statement,=20 or that I can insert large amounts of data ?
 
Thanks
Alex
--Boundary_(ID_JCxJTEYk10quLMdDSLCxYQ)--