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

Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)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
>