Обсуждение: 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@sss.pgh.pa.us]
Sent: Tuesday, February 17, 2004 8:49 PM
To: Rajan Bhide
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Error: query is too long. Maximum length is 16382


"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-sidecode. 

            regards, tom lane

"Rajan Bhide" <rbhide@nulinkinc.com> writes:
> But I am not sure abt the MAX LIMIT with 7.4.1.

There isn't one ... until you run out of memory.

            regards, tom lane