Re: using index with bigint pkey - Mailing list pgsql-jdbc

Éric Paré wrote:

> I found that running a simple query on a bigint index does not behave as
> expected in the planner.  This query does not use the index on 'a pkey
> id column' if it is of bigint type :

> Note on setup :
> - postgresql 7.4.1 server
> - postgresql-7.4.1-jdbc3.jar

Use an 8.0 server (allows cross-type index use), or the development JDBC
driver (sends longs as BIGINT via the V3 protocol).

-O