Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: Patch to add a primary key using an existing index
Date
Msg-id 4CFABD16.7010601@agliodbs.com
Whole thread Raw
In response to Re: Patch to add a primary key using an existing index  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On 12/04/2010 12:37 PM, Robert Haas wrote:
> What would make sense to me is: create a pk constraint with the sane name as the existing unique index.  If that
constraintname already exists, error.
 

+1, agreed.  Based on this, the syntax should be obvious.

We'll need to doc what to do in the event of a name collision error, 
though (rename the other constraint).  Hmmm, can you rename a constraint?

--                                   -- Josh Berkus                                     PostgreSQL Experts Inc.
                           http://www.pgexperts.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: knngist - 0.8
Next
From: Andrew Dunstan
Date:
Subject: Re: SQL/MED - file_fdw