Re: Why sequential scan for currval? - Mailing list pgsql-general

> test=# explain select s from tt where id = currval('tt_id_key');
>                       QUERY PLAN
> ------------------------------------------------------
>  Seq Scan on tt  (cost=0.00..1734.42 rows=1 width=32)
>    Filter: (id = currval('tt_id_key'::text))
> (2 rows)

should be:

test=# explain select s from tt where id = currval('tt_id_seq'); --
tt_id_seq vs. tt_id_key
                      QUERY PLAN
------------------------------------------------------
 Seq Scan on tt  (cost=0.00..1734.42 rows=1 width=32)
   Filter: (id = currval('tt_id_seq'::text))
(2 rows)

but the question still holds.

  John