Error: query is too long. Maximum length is 16382

From: "Rajan Bhide" <rbhide(at)nulinkinc(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Error: query is too long. Maximum length is 16382
Date: 2004-02-17 14:52:53
Message-ID: FF851C7EEB75954F9BCFB5CA117AB1EC674221@delta.nulinkinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-02-17 15:19:24 Re: Error: query is too long. Maximum length is 16382
Previous Message B. Nielsen 2004-02-17 12:33:10 Unable to connect to PostgreSQL server: