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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Better name/syntax for "online" index creation
Дата
Msg-id 200607241738.32609.peter_e@gmx.net
обсуждение исходный текст
Ответ на Better name/syntax for "online" index creation  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Better name/syntax for "online" index creation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Am Montag, 24. Juli 2006 17:13 schrieb Tom Lane:
> To my mind, "ONLINE" just doesn't convey any useful information ---
> the existing CREATE INDEX functionality could already be said to be
> "online", in the sense that you don't have to take down the database
> to do it.  I thought about "SHARED" but someone could probably raise
> the same objection to it.  Anyone have a better idea?

CONCURRENTLY

> 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?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


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

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