Re: Very vague pg_dump question ...

"Marc G. Fournier" <scrappy@postgresql.org> writes:
> I'm currently looking into a problem that a client is reporting that 
> pg_dump from 8.0.3 is 'skipping' one of their sequences ... I'm waiting 
> for more info, but am curious if anyone knows (or can think of?) any 
> reason why this might happen?  The only thing I can think of is that the 
> sequence is owned by someone other then who the database is being dump'd 
> as, and has no permissions to 'read' it ... but anything I'm not thinking 
> of?

AFAIK, a permissions problem would result in a pretty obvious error
message from pg_dump ... though it's certainly possible for someone
to ignore that, especially if they are running pg_dump noninteractively.

Skipping in what sense --- no DDL, no setval, both?  Is this a
separately created sequence or a SERIAL sequence?
        regards, tom lane