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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Rod Taylor <pg(at)rbt(dot)ca>, Greg Stark <gsstark(at)mit(dot)edu>
Subject: Re: Better name/syntax for "online" index creation
Date: 2006-07-25 13:46:50
Message-ID: 200607251546.52160.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-07-25 13:59:01 buildfarm web extensions - help wanted
Previous Message Dave Page 2006-07-25 13:42:09 Re: root/administartor user check option.