Re: Query planner isn't using my indices - Mailing list pgsql-general

"Alaric B. Snell" <abs@frontwire.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