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

Peter Eisentraut <peter_e(at)gmx(dot)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