dbTalk Databases Forums  

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

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Re: Error: query is too long. Maximum length is 16382 in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rajan Bhide
 
Posts: n/a

Default Re: Error: query is too long. Maximum length is 16382 - 02-18-2004 , 08:14 AM






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.pa.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:
Quote:
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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly



Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: Error: query is too long. Maximum length is 16382 - 02-18-2004 , 09:57 AM






"Rajan Bhide" <rbhide (AT) nulinkinc (DOT) com> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.