Re: Making serial survive pg_dump - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Making serial survive pg_dump
Date
Msg-id 06b301c21325$3444d880$fe01a8c0@jester
Whole thread Raw
In response to Making serial survive pg_dump  ("Rod Taylor" <rbt@zort.ca>)
Responses Re: Making serial survive pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
If we have sequences pick new names automatically, it may not pick the
same name after dump / restore as it had earlier -- especially across
versions (see TODO entry).

So don't we need a way to suggest the *right* name to SERIAL?

--
Rod
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Rod Taylor" <rbt@zort.ca>
Cc: "Hackers List" <pgsql-hackers@postgresql.org>
Sent: Thursday, June 13, 2002 5:52 PM
Subject: Re: [HACKERS] Making serial survive pg_dump


> "Rod Taylor" <rbt@zort.ca> writes:
> > Normally I'd agree, but I've found a few people who use normal
> > sequence operations with serial sequences.  That is, they track
down
> > the name and use it.
>
> Sure.  But what's this have to do with what pg_dump should emit?
>
> regards, tom lane
>



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Making serial survive pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Making serial survive pg_dump