
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
==========================================================================




Thu, 6 Apr 2000 09:52:58 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
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

Thu, 06 Apr 2000 11:05:09 -0400
Tom Lane <tgl@sss.pgh.pa.us>
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!

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
==========================================================================




Thu, 6 Apr 2000 12:07:53 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: pg_dump and serial 