"Rod Taylor" <rbt@zort.ca> writes:
>> What happens is the sequence is shared between several tables (eg.
>> invoice numbers or something)
> You cannot accomplish this situation by strictly using the SERIAL
> type.
But Chris is correct that there are borderline cases where we might
do the wrong thing if we're not careful. The real question here,
I suspect, is what rules pg_dump will use to decide that it ought
to suppress a CREATE SEQUENCE command, DEFAULT clause, etc, in
favor of emitting a SERIAL column datatype. In particular, ought it
to depend on looking at the form of the name of the sequence?
I can see arguments both ways on that...
regards, tom lane