Re: Renaming a constraint's index - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Renaming a constraint's index
Date
Msg-id 478F7B0E.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Renaming a constraint's index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>> On Wed, Jan 16, 2008 at  5:20 PM, in message <29518.1200525640@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 2. Make ALTER INDEX RENAME automatically rename the constraint, too.

> 3. Invent an ALTER TABLE RENAME CONSTRAINT command, and have it also
> rename the underlying index.
> I'm thinking about doing #2 for 8.3 and leaving #3 as a TODO item.
+1
Something should be done for 8.3 to prevent unusable dumps.
The absence of primary key rename has been mildly annoying at times.
I don't see any problem with allowing it to work both ways.
-Kevin




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple thing to make pg_autovacuum more useful
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Simple thing to make pg_autovacuum more useful