pg_dump and serial

Started by Vince Vielhaberabout 26 years ago3 messageshackers

vev@michvhf.com

about 26 years ago

IIRC there was a problem with pg_dump and the serial datatype. I'm about
to do some massive upgrades and part of it is going to 7.0 from 6.5.? I
use serial datatypes heavily and reference them in other tables (userid,
accountnumber, etc). Will pg_dump and the psql < dumpfile restore the
serials and have the serials still work?

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

Tom Lane

tgl@sss.pgh.pa.us

about 26 years ago

In reply to: Vince Vielhaber (#1)

Re: pg_dump and serial

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

Vince Vielhaber

vev@michvhf.com

about 26 years ago

In reply to: Tom Lane (#2)

Re: pg_dump and serial

On Thu, 6 Apr 2000, Tom Lane wrote:

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.

Cool!