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

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
>