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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Patch to add a primary key using an existing index
Дата
Msg-id 1291404231.30414.0.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Patch to add a primary key using an existing index  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Patch to add a primary key using an existing index  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On sön, 2010-11-28 at 20:40 -0500, Robert Haas wrote:
> 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;

I would think that that determines that name of the index that the
command creates.  It does not convey that an existing index is to be
used.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: should we set hint bits without dirtying the page?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Patch to add a primary key using an existing index