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 1291576171.10677.2.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  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Список pgsql-hackers
On fre, 2010-12-03 at 15:27 -0500, Robert Haas wrote:
> 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.

That could be avoided by writing

USING INDEX <name>



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: profiling connection overhead
Следующее
От: Rob Wultsch
Дата:
Сообщение: Re: profiling connection overhead