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

Am Dienstag, 25. Juli 2006 06:55 schrieb Bruce Momjian:
> Or maybe CREATE INDEX x ON tab NOLOCK....  Having the NOLOCK
> associated with the table name makes sense.

Semantically, NOLOCK (or whatever word) seems most closely associated with 
CREATE INDEX, so having it as third word would make sense, and it would be 
quite easy to parse for psql.

Strictly speaking, however, it would have to be NOLOCKLY in that case. :-)

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