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(at)pacbell(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general