Re: pg_dump versus SERIAL, round N - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump versus SERIAL, round N
Date
Msg-id 29366.1156099610@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump versus SERIAL, round N  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> 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


pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Windows 2000 Support
Next
From: Tom Lane
Date:
Subject: Re: pg_dump versus SERIAL, round N