Thread

1. select problem

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-03-01T18:37:49Z

   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
   
   
   

2. Re: select problem

   Peter T 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