| From: | Alexander F Hartner <alex001(at)global(dot)co(dot)za> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Insert / Update Statement |
| Date: | 1999-10-09 10:15:46 |
| Message-ID: | 000701bf123f$416c00e0$8948ef9b@heaven.global.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nickyk | 1999-10-09 17:07:26 | Rule question |
| Previous Message | Tom Lane | 1999-10-08 14:43:01 | Re: [SQL] Questions about vacuum analyze |