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

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Patch to add a primary key using an existing index
Дата
Msg-id 20101129065840.GC1942@fetter.org
обсуждение исходный текст
Ответ на Re: Patch to add a primary key using an existing index  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Sun, Nov 28, 2010 at 08:40:08PM -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;

+1 :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: pg_execute_from_file review
Следующее
От: Christoph Berg
Дата:
Сообщение: [trivial patch] Ellipsis whitespace in SQL docs