Error: query is too long. Maximum length is 16382

Поиск
Список
Период
Сортировка
От Rajan Bhide
Тема Error: query is too long. Maximum length is 16382
Дата
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC674221@delta.nulinkinc.com
обсуждение исходный текст
Ответы Re: Error: query is too long. Maximum length is 16382  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Дерево обсуждения
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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Maximilian Tyrtania
Дата:
Сообщение: Moving from Openbase to Postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error: query is too long. Maximum length is 16382