Re: SQL statement is too long - Mailing list pgsql-novice

From Tom Lane
Subject Re: SQL statement is too long
Date
Msg-id 9908.1069398097@sss.pgh.pa.us
Whole thread Raw
In response to SQL statement is too long  ("Miia Leino" <miia.leino@zeerio.com>)
List pgsql-novice
"Miia Leino" <miia.leino@zeerio.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Does it exist a embedded server ?
Next
From: Roy MacGregor Paterson
Date:
Subject: Postmaster running, psql not