Обсуждение: pg_dump and serial
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 ==========================================================================
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
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 ==========================================================================