Re: rename index?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: rename index?
Дата
Msg-id 200111220312.fAM3CUm08995@candle.pha.pa.us
обсуждение исходный текст
Ответ на rename index?  (mlw <markw@mohawksoft.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: rename index?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Diff/Patch integration -> SQL cvs clone