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 48252F3B.6020406@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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>> Bruce Momjian wrote:
>>> Any comments, ideas, suggestions?
> 
>> I would add:
> 
>>    5. Modify index name to use appropriate naming style.
> 
> 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:

create table foo (id serial primary key);

I end up with "foo_pkey" PRIMARY KEY, btree (id)

Which is nice for consistency.

Sincerely,

Joshua D. Drake

> 
>             regards, tom lane
> 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: "Claimed" status on Commitfest pages
Next
From: "Brendan Jurd"
Date:
Subject: Re: "Claimed" status on Commitfest pages