However, of course the best thing is to just fix it, which I guess I'll have a crack at...
Given that pg_dump does put out GRANT/REVOKE operations on the sequence, it's certainly aware that the sequence exists. I suspect this is just a fixable bug (ie, suppression of output of the sequence CREATE command is being done at the wrong place).
Hrm. This seems to be a bug introduced when I moved the OWNER TO commands to be dumped after each object's definition is dumped, instead of just before their ACL is dumped.
The problem is that although the SERIAL sequence has an ACL, it has no object, so it never has an OWNER TO command dumped.
I'm trying to think of the solution here. I guess we can move the OWNER TO commands to be dumped in the ACL phase, or we can make a special exception for serial sequences.
Also, are there any other objects that are going to have this problem? Off the top of my head it's only serial sequences.
What's the best solution? I guess we have to put them back on the acl_pass?
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
