On Fri, 1 Mar 2002, Victor Krasinsky wrote:
> Is it a known bug if optimizer, that Postgres can't use indexes created on a int8 (bigint) ?
> This problem exists in 7.1.3 and even in 7.2.
You need to explicitly cast the constant that you're comparing to
bigint (1::bigint or CAST(1 as bigint)).