Re: Making serial survive pg_dump

From: "Rod Taylor" <rbt(at)zort(dot)ca>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Making serial survive pg_dump
Date: 2002-06-13 21:56:42
Message-ID: 06b301c21325$3444d880$fe01a8c0@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rod Taylor" <rbt(at)zort(dot)ca>
Cc: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Sent: Thursday, June 13, 2002 5:52 PM
Subject: Re: [HACKERS] Making serial survive pg_dump

> "Rod Taylor" <rbt(at)zort(dot)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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-13 22:05:12 Re: Making serial survive pg_dump
Previous Message Tom Lane 2002-06-13 21:52:34 Re: Making serial survive pg_dump