>>> On Wed, Jan 16, 2008 at 5:20 PM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend