Re: select problem

At 13:37 01/03/01 -0500, pgsql-bugs(at)postgresql(dot)org wrote:
>Elie Atallah (elieatallah(at)hotmail(dot)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