Re: Very vague pg_dump question ...

Marc,

> 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?

I've encountered databases where a continuous upgrade from 7.2 can cause 
bad dependencies which make certain objects get dropped.   Usually running 
pg_depends fixes this.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco