On Fri, 8 Jul 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> 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?
This is what I'm still looking to find out ... all I got was "the sequence
isn't being recreated in the dump", and when I message the client back, I
get a vacation message, so obviously it wasn't a critical bug for them
*roll eyes*
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
