postgres length limitation query

Started by Enrico Manganoabout 25 years ago2 messagesgeneral
Jump to latest
#1Enrico Mangano
enrico.mangano@nethouse.it

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

Thanks.

#2Michael Ansley
Michael.Ansley@intec-telecom-systems.com
In reply to: Enrico Mangano (#1)
RE: postgres length limitation query

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
**********************************************************************