Re: view table pkey values

Got it!  Yes, this started happening after loading from a pg_dump.
Thanks for the explanation!
Scott



On Aug 24, 2009, at 10:52 AM, Tom Lane wrote:

> Scott Frankel <leknarf@pacbell.net> writes:
>> Is there a command that lists the values for the internal,
>> foo_foo_id_seq, sequence?
>
> select * from foo_foo_id_seq;
>
> The usual way to get into this sort of trouble is to load a bunch of
> data into the table while explicitly specifying ID values.  It will
> take the data (as long as it doesn't conflict with existing IDs)
> but nothing happens to the sequence.  pg_dump knows it has to update
> the sequence too, but a lot of other tools don't; and even with
> pg_dump
> a selective restore can mess things up.
>
>             regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general