Re: rename index?

> Tom Lane wrote:
> >
> > ALTER TABLE RENAME works on indexes (at least in recent releases).
> >
> > regards, tom lane
>
> OH, stupid me, I didn't get what you meant. Treat the index name as the table
> name, i.e.
>
> alter table fubar_idx rename to fubar_idx_old;
>
> Yes, that works, but I would never have guessed that. Is that what Postgres
> should be doing?
>
> Might not it be useful to have an "alter Object ..." which will work on
> Postgres objects, like sequences, functions, etc. to make general changes.
> Using alter table to rename an index seems a bit arcane.

We have already forced DROP object to honor the object type, so ALTER
TABLE should do the same, right? Do we need to add an ALTER INDEX
command, and an ALTER SEQUENCE command too? Maybe ALTER NONTABLE? :-)

Added to TODO:

o Prevent ALTER TABLE RENAME from renaming indexes and sequences (?)

We can figure out figure out later how we want to address this.

--
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