Re: pg_dump and serial - Mailing list pgsql-hackers

From Vince Vielhaber
Subject Re: pg_dump and serial
Date
Msg-id Pine.BSF.4.05.10004061207370.2679-100000@paprika.michvhf.com
Whole thread Raw
In response to Re: pg_dump and serial  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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
 
==========================================================================





pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: 7.1 items
Next
From: Karel Zak
Date:
Subject: Re: pg_dumplo, thanks :) (fwd)