Thread: postgres length limitation query

Hello,
is there any limit in the length of a query?
What postgres does if I give it a query that is bigger?

Thanks.

If you're talking about the length of the query string, it should be limited only by the memory available to the processes that handle it.  If they run out of memory, it all goes pop! and then releases the used memory, and should carry on working ;-)

MikeA

-----Original Message-----
From: Enrico Mangano [mailto:enrico.mangano@nethouse.it]
Sent: 15 February 2001 08:39
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres length limitation query

Hello,
is there any limit in the length of a query?
What postgres does if I give it a query that is bigger?

Thanks.

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************