Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: Patch to add a primary key using an existing index
Date
Msg-id AANLkTin3XHvfGS_Qw_Art1MTQRkdqnyC0A3VvuFNTpnE@mail.gmail.com
Whole thread Raw
In response to Re: Patch to add a primary key using an existing index  (r t <pgsql@xzilla.net>)
Responses Re: Patch to add a primary key using an existing index  (Josh Berkus <josh@agliodbs.com>)
Re: Patch to add a primary key using an existing index  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
On Fri, Dec 3, 2010 at 2:56 PM, r t <pgsql@xzilla.net> wrote:
> What exactly was the objection to the following -->
> ALTER TABLE table_name ADD PRIMARY KEY (column_list) USING index_name;
> Is the objection that you might have been trying to specify a constraint
> named "using" ? I'm willing to make that option more difficult. :-)

I think it's that someone might expect the word after USING to be the
name of an index AM.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+
Next
From: Josh Berkus
Date:
Subject: Re: Patch to add a primary key using an existing index