Postgres Pro
Downloads
Home   >   mailing lists

Error: query is too long. Maximum length is 16382 - Mailing list pgsql-novice

From Rajan Bhide
Subject Error: query is too long. Maximum length is 16382
Date
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC674221@delta.nulinkinc.com
Whole thread Raw
Responses Re: Error: query is too long. Maximum length is 16382  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Maximilian Tyrtania
Date:
Subject: Moving from Openbase to Postgres
Next
From: Tom Lane
Date:
Subject: Re: Error: query is too long. Maximum length is 16382