> pg_dump will just emit "create table t1 (f1 serial)" with no hint that
> the sequence ought to be set to CYCLE mode. I'm not sure about an
> appropriate fix offhand --- we can't very well use ALTER SEQUENCE in
> just this way in the dump, because of the risk of the sequence name
> being possibly different at reload. (Come to think of it, we are not
> very good about propagating GRANTs on the sequence either, because of
> the same risk.)
I suggest some time ago an alternative syntax for ALTER SEQUENCE. So,
you'd have:
ALTER SEQUENCE seqname ...
or
ALTER SEQUENCE ON table.column ...
or something.
Then it would be similar to have pg_get_serial_sequence() works.
Chris