Thread

Re: select problem

Peter Mount <peter@retep.org.uk> — 2001-03-01T21:13:59Z

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