Postgres Pro
Downloads
Home   >   mailing lists

Re: Patch to add a primary key using an existing index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Patch to add a primary key using an existing index
Date
Msg-id 10915.1291924128@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch to add a primary key using an existing index  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Patch to add a primary key using an existing index  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Patch to add a primary key using an existing index  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-hackers
Tree view 
Gurjeet Singh <singh.gurjeet@gmail.com> writes:
> But I still hold a bias towards renaming the index to match constraint name
> (with a NOTICE), rather than require that the constraint name match the
> index name, because the constraint name is optional and when it is not
> provided system has to generate a name and we have to rename the index
> anyway to maintain consistency.

No.  If the constraint name is not specified, we should certainly use
the existing index name, not randomly rename it.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Patch to add a primary key using an existing index
Next
From: "Kevin Grittner"
Date:
Subject: Re: Patch to add a primary key using an existing index