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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org