Re: rename index?

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026