Problem with query length - Mailing list pgsql-hackers

From Natalya S. Makushina
Subject Problem with query length
Date
Msg-id 01BEE8D4.0F1D6CD0@makushina.rtsoft.msk.ru
Whole thread Raw
List pgsql-hackers
-----------------------------------------------------------------------------------------------------------------------------
I have posted this mail to psql-general.  But i didn't get any answer yet.

-----------------------------------------------------------------------------------------------------------------------------

When i had tried to insert into text field text (length about 4000 chars), the backend have crashed with status 139.
Thiserror is happened when the query length ( SQL query) is more than 4095 chars. I am using PostgreSQL 6.4.2 on
Linux.

My questions are:
1. Is there problem with text field or with length of SQL query?
2. Would postgresql have any limits for SQL query length?
I checked the archives but only found references to the 8K limit. Any help would be greatly appreciated.
Thanks for help            Natalya Makushina             mak@rtsoft.msk.ru



pgsql-hackers by date:

Previous
From: "Natalya S. Makushina"
Date:
Subject: Problem with query length
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] backend freezeing on win32 fixed (I hope ;-) )