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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
