Skip site navigation (1) Skip section navigation (2)

Re: pg_dump and serial

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vince Vielhaber <vev(at)michvhf(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: pg_dump and serial
Date: 2000-04-06 15:05:09
Message-ID: 27078.955033509@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Vince Vielhaber <vev(at)michvhf(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-04-06 15:12:45
Subject: Book and TEMP vs. TEMPORARY
Previous:From: Hiroshi InoueDate: 2000-04-06 15:01:05
Subject: 7.0 like selectivity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group