Re: Error from pg_dump

> Yesterday, when our nightly database backup was running, it errored out
> with the following error from pg_dumpall:
>
> dumpSequence(contact_seq): different sequence name returned by SELECT:
> contact_sequence

Hmm.... I just found the problem. (Maybe I should think more before I
send these?)

iboats=# select sequence_name from contact_seq;
sequence_name
------------------
contact_sequence
(1 row)

---------------------------------------

So, trying to "update" it won't work, I suppose I'll have to drop the
sequence and create it again. (If there are any other suggestions, please
let me know). Anybody know how something like that could happen?

steve