Re: Select where id in (LARGE LIST) ?

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jasper Potts <jasper(at)jasperpotts(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Select where id in (LARGE LIST) ?
Date: 2005-08-02 23:54:38
Message-ID: 42F007BE.8040002@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Jasper Potts wrote:
> I know from when I was testing "SELECT ... WHERE id IN (...,...)" I got
> a buffer over flow or similar exception from the postgresql native
> process at about 200-300 longs in the IN clause.

Well I'd need to see the actual exception not a vague description of it
to comment further.

> Could do with finding
> what the real limits are so I can protect against it. I will have a dig
> though the documentation later see what I can find :-)

There may be a (backend) limit on the number of parameters in a query,
not sure.

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-08-02 23:55:23 Re: some improve JDBC
Previous Message Víctor Pérez Juárez 2005-08-02 17:34:59 some improve JDBC