Re: Patch to add a primary key using an existing index

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Patch to add a primary key using an existing index
Дата
Msg-id AANLkTi=xA+JyEHukcTC_EFUYs7_jiryrS6YEaZS5+Efg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch to add a primary key using an existing index  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Ответы Re: Patch to add a primary key using an existing index  (David Fetter <david@fetter.org>)
Re: Patch to add a primary key using an existing index  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: profiling connection overhead
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [GENERAL] column-level update privs + lock table