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

From Tom Lane
Subject Re: Setting a pre-existing index as a primary key
Date
Msg-id 2126.1210432237@sss.pgh.pa.us
Whole thread Raw
In response to Re: Setting a pre-existing index as a primary key  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Setting a pre-existing index as a primary key  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> Why, and exactly what would you define as "appropriate naming style"?
>> The user has always been free to pick whatever constraint name he
>> wants.

> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: bloated heapam.h
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Setting a pre-existing index as a primary key