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

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/