| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Miia Leino" <miia(dot)leino(at)zeerio(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: SQL statement is too long |
| Date: | 2003-11-21 07:01:37 |
| Message-ID: | 9908.1069398097@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Miia Leino" <miia(dot)leino(at)zeerio(dot)com> writes:
> I'm using PostgreSQL 7.2.3-2. Now with one insert that is trying to put
> long string to the text typed field postgre is giving an error SQL
> statement is too long.
The backend limit on SQL statement length was long gone in 7.2. But
IIRC there were still some client libraries that hadn't gotten the word,
and would "helpfully" complain instead of sending what had once been an
overlength query.
The short answer is to update your Postgres installation, client
libraries as well as server. 7.2.3 is pretty long in the tooth anyway.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vellinga, Fred | 2003-11-21 08:54:36 | addnew in combination with Limt |
| Previous Message | Tom Lane | 2003-11-21 06:56:12 | Re: Does it exist a embedded server ? |