Re: Better name/syntax for "online" index creation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Better name/syntax for "online" index creation
Дата
Msg-id 11363.1153756529@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Better name/syntax for "online" index creation  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Montag, 24. Juli 2006 17:13 schrieb Tom Lane:
>> I'm tempted to put the new keyword at the very front:
>> 
>> SHARED CREATE INDEX ....
>> 
>> which would probably mean that we'd have to document it as if it were a
>> completely separate command from CREATE INDEX, but then again that might
>> not be a bad thing considering how differently the two cases behave.

> What is so different about them that would justify this?

Well, mainly it's exactly the reason that psql wants to know the
difference: one can be executed inside a transaction block, and the
other one can't.  To my mind that's a sufficiently big difference
that it deserves a different command name.  We messed this up with
CLUSTER but that's not a precedent I want to follow.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name