Re: Setting a pre-existing index as a primary key - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Setting a pre-existing index as a primary key
Date
Msg-id 4825C012.4000803@commandprompt.com
Whole thread Raw
In response to Re: Setting a pre-existing index as a primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Setting a pre-existing index as a primary key
Next
From: Andrew Dunstan
Date:
Subject: Re: Setting a pre-existing index as a primary key