Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump and serial

pg_dump and serial

From
Vince Vielhaber
Date:
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.net128K ISDN from $22.00/mo - 56K Dialup from
$16.00/moat Pop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop
Superstore   http://www.cloudninegifts.com
 
==========================================================================

Re: pg_dump and serial

From
Tom Lane
Date:
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

Re: pg_dump and serial

From
Vince Vielhaber
Date:
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!

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