Vince Vielhaber <vev(at)michvhf(dot)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