BUG #1326: Unique and Primary Key index over bigint type doesn't work

The following bug has been logged online:

Bug reference: 1326
Logged by: Fernando Kasten Peinado

Email address: fernandopeinado(at)uol(dot)com(dot)br

PostgreSQL version: 7.4.5

Operating system: Linux RedHat 7.3

Description: Unique and Primary Key index over bigint type doesn't
work

Details:

index is not used when Type is bigint.

sislu=> \d x
Table "public.x"
Column | Type | Modifiers
--------+------------------------+-----------
id | bigint | not null
name | character varying(100) |
age | integer |
bigid | bigint |
Indexes:
"x_pkey" primary key, btree (id)
"un_x_age" unique, btree (age)
"un_x_bigid" unique, btree (bigid)
"un_x_name" unique, btree (name)

sislu=> explain select * from x where x.id = 12345;
QUERY PLAN
---------------------------------------------------
Seq Scan on x (cost=0.00..22.50 rows=2 width=88)
Filter: (id = 12345)
(2 rows)

sislu=> explain select * from x where x.bigid = 12345;
QUERY PLAN
---------------------------------------------------
Seq Scan on x (cost=0.00..22.50 rows=2 width=88)
Filter: (bigid = 12345)
(2 rows)

sislu=> explain select * from x where x.name = 'asdf';
QUERY PLAN
--------------------------------------------------------------------
Index Scan using un_x_name on x (cost=0.00..4.82 rows=2 width=88)
Index Cond: ((name)::text = 'asdf'::text)
(2 rows)

sislu=> explain select * from x where x.age = 1;
QUERY PLAN
-------------------------------------------------------------------
Index Scan using un_x_age on x (cost=0.00..4.82 rows=2 width=88)
Index Cond: (age = 1)
(2 rows)