Re: pg_dump and serial - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and serial
Date
Msg-id 27078.955033509@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and serial  (Vince Vielhaber <vev@michvhf.com>)
Responses Re: pg_dump and serial  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-hackers
Vince Vielhaber <vev@michvhf.com> writes:
> IIRC there was a problem with pg_dump and the serial datatype.

? I've been dumping/restoring serials for a long time without problems.
The only gotcha I can think of is that dumping a single table (-t foo)
doesn't work nicely --- pg_dump doesn't realize that the sequence for
a serial column of foo needs to be included.  But as long as you're
dumping a whole database, no problem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: 7.0 like selectivity
Next
From: Bruce Momjian
Date:
Subject: Book and TEMP vs. TEMPORARY