"Alaric B. Snell" <abs(at)frontwire(dot)com> writes:
> frontwire=# \d stakeholder_pk
> Index "stakeholder_pk"
> Attribute | Type
> -----------+--------
> id | bigint
> unique btree
> frontwire=# explain select * from stakeholder where id = 1;
> NOTICE: QUERY PLAN:
> Seq Scan on stakeholder (cost=0.00..602.81 rows=1 width=336)
Try "where id = 1::bigint" or "where id = '1'".
Unadorned 1 is an int4, not an int8 ... see archives for previous
discussions.
regards, tom lane