Re: Better name/syntax for "online" index creation - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Better name/syntax for "online" index creation
Date
Msg-id 200607241738.32609.peter_e@gmx.net
Whole thread Raw
In response to Better name/syntax for "online" index creation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Better name/syntax for "online" index creation  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Next
From: Tom Lane
Date:
Subject: Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name