Обсуждение: Error: query is too long. Maximum length is 16382

Поиск
Список
Период
Сортировка

Error: query is too long. Maximum length is 16382

От
"Rajan Bhide"
Дата:
Hi Folks,
 
Following is the Error string returned by Postgres Server for insert query of approx 32k in length.
 
Postgres Version : 7.2.4
PQsendQuery() -- query is too long.  Maximum length is 16382.
 
Is this limit modifiable by changing BLCKSZ of include/config.h as suggested in forum?
http://archives.postgresql.org/pgsql-hackers/1999-07/msg00398.php
 
What changes to be done to able to perform insert of approx 32k with a single query?
 
Also where can I find the latest documentated Maximum Length for the Query?
 
Thanks in advance,
Rajan

Re: Error: query is too long. Maximum length is 16382

От
Tom Lane
Дата:
"Rajan Bhide" <rbhide@nulinkinc.com> writes:
> Postgres Version : 7.2.4
> PQsendQuery() -- query is too long.  Maximum length is 16382.

That error message has not existed in libpq since sometime before 7.0.
Better take another look at the age of your client-side code.

            regards, tom lane