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

Hi Tom,

I was using 7.1.3 on linux(debian), and not 7.2.4, so sorry for that.
Recently I migrated to 7.4.1 version of postgres, And I cud NOT see the error msgs any more.
Tested with insert query around 64k(65536).
But I am not sure abt the MAX LIMIT with 7.4.1.
Can you tell me the latest MAX LIMIT on the insert query, or wat MAX LENGTH query I can fire by changing which constants?
Any pointers/reference wud be greatly appriciated.
FYI, I have not made any changes to BLKSZ and its 8192 only.

Thanks,
Rajan

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, February 17, 2004 8:49 PM
To: Rajan Bhide
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Error: query is too long. Maximum length is 16382

"Rajan Bhide" <rbhide(at)nulinkinc(dot)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