Thread: select problem

Elie Atallah (elieatallah@hotmail.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
select problem

Long Description
I'm using JDBC as an interface.

The select query will be dynamicly built. In some situation the query string can reach a big length of characters (per
example:33000 characters) what postgresql doesn't accept. 


Question:
Is there a limit for the query string?
If yes witch one.

please mail me as soon as possible (it's important for my master thesis).

Thank you in advance.


Elie Atallah

Sample Code
String query=" a string query about 33000 characters";
execute(query);

No file was uploaded with this report

At 13:37 01/03/01 -0500, pgsql-bugs@postgresql.org wrote:
>Elie Atallah (elieatallah@hotmail.com) reports a bug with a severity of 2
>The lower the number the more severe it is.
>
>Short Description
>select problem
>
>Long Description
>I'm using JDBC as an interface.
>
>The select query will be dynamicly built. In some situation the query
>string can reach a big length of characters (per example: 33000
>characters) what postgresql doesn't accept.
>
>
>Question:
>Is there a limit for the query string?
>If yes witch one.

Under 7.1 there is no limit. However as JDBC's DatabaseMetaData expects to
return a value for a call, it's says 64K. However this shouldn't really
affect anything, it's just a returned value.

Pre 7.1 was limited to 8k.

These were backend limitations not JDBC.

Peter