Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group