Re: Maximum length of a query

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Antony Paul <antonypaul24(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Maximum length of a query
Date: 2005-02-09 07:31:35
Message-ID: 20050209073135.GA88890@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Feb 09, 2005 at 11:43:20AM +0530, Antony Paul wrote:
>
> What is the maximum length allowed for a query in PG 7.3.3 ?. I
> need arbitrarily long queries to be executed through JDBC.

According to the following message from Tom Lane, "There is no
specific limit; it'll depend on available memory and complexity of
the statement."

http://archives.postgresql.org/pgsql-general/2003-12/msg01373.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message drdani 2005-02-09 07:53:39 copy rows
Previous Message Antony Paul 2005-02-09 06:45:51 How to know a temp table exists ?