Bruce Momjian <[EMAIL PROTECTED]> writes: > Also, if someone restores one table, does the sequence come with it like > it does now with SERIAL?
Hm, probably not. I do have pg_dump set to force dumping of the sequence if you try to dump just its table, but it'd be possible to tell pg_restore (via -l) to load only the table, which could fail. I'm not too excited about that though; there are plenty of other ways to tell pg_restore to restore a database subset that won't work. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster