Re: Setting a pre-existing index as a primary key

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Setting a pre-existing index as a primary key
Дата
Msg-id 4825C012.4000803@commandprompt.com
обсуждение исходный текст
Ответ на Re: Setting a pre-existing index as a primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Setting a pre-existing index as a primary key  (Andrew Dunstan <andrew@dunslane.net>)
Re: Setting a pre-existing index as a primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Setting a pre-existing index as a primary key  (Tino Wildenhain <tino@wildenhain.de>)
Re: Setting a pre-existing index as a primary key  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Tom Lane wrote:

>> Well it should be optional but it would be nice if we had the option to 
>> have it renamed per the default... meaning the same output if I were to 
>> do this:
> 
> If you want that, you can rename the index (either before or afterwards).
> I don't see any reason to clutter the make-constraint-from-index command
> with questions of renaming.

As a counter point, I don't see any reason to make the DBA's life 
harder. Sure it is just one step but it is a human step, prone to error 
and taking more time than it should. Why not just make it easy? 
Especially when the easy isn't sacrificing data integrity or quality of 
product?


Sincerely,

Joshua D. Drake


> 
>             regards, tom lane
> 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Setting a pre-existing index as a primary key
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Setting a pre-existing index as a primary key