Re: using index with bigint pkey

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: paree(at)LEXUM(dot)UMontreal(dot)CA
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: using index with bigint pkey
Date: 2004-11-26 00:00:16
Message-ID: 41A67210.8010206@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message deepthi 2004-11-26 07:05:47 Time conversion across various parts of world
Previous Message Éric Paré 2004-11-25 23:39:36 using index with bigint pkey