Re: rename index? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: rename index?
Date
Msg-id 200111220312.fAM3CUm08995@candle.pha.pa.us
Whole thread Raw
In response to rename index?  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Added to TODO:
> >         o Prevent ALTER TABLE RENAME from renaming indexes and sequences (?)
> 
> This would clearly be a step backwards, unless we provide alternate
> syntax.
> 
> While it's maybe a tad inconsistent to allow ALTER TABLE RENAME to work
> on the other relation types, I'm having a hard time getting excited about
> doing any work just to be more rigid about it.  There's a good reason
> for DROP to be extremely tight about what it will do: you can't always
> undo it.  So the more checking we can do to be sure you meant what you
> said, the better.  OTOH a mistaken RENAME is easy enough to undo, so I'm
> not so concerned about having very tight consistency checking on it.

Good point!  Item removed from TODO.  I will add documentation about
this capability.  Thanks.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: rename index?
Next
From: Bruce Momjian
Date:
Subject: Re: Diff/Patch integration -> SQL cvs clone