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 AANLkTi=xA+JyEHukcTC_EFUYs7_jiryrS6YEaZS5+Efg@mail.gmail.com
Whole thread Raw
In response to Re: Patch to add a primary key using an existing index  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: Patch to add a primary key using an existing index
Re: Patch to add a primary key using an existing index
List pgsql-hackers
On Sun, Nov 28, 2010 at 8:06 PM, Itagaki Takahiro
<itagaki.takahiro@gmail.com> wrote:
> On Fri, Nov 26, 2010 at 05:58, Steve Singer <ssinger@ca.afilias.info> wrote:
>> The attached version of the patch gets your regression tests to pass.
>> I'm going to mark this as ready for a committer.
>
> I think we need more discussions about the syntax:
>  ALTER TABLE table_name ADD PRIMARY KEY (...) WITH (INDEX='index_name')

Why not:

ALTER TABLE table_name ADD PRIMARY KEY (...) INDEX index_name;

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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: profiling connection overhead
Next
From: Robert Haas
Date:
Subject: Re: [GENERAL] column-level update privs + lock table