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

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Greg Stark <gsstark(at)mit(dot)edu>
Subject: Re: Better name/syntax for "online" index creation
Date: 2006-07-24 15:22:03
Message-ID: 1153754523.763.87.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry, hit send too quickly.

NOLOCK is kinda like NOWAIT, except implies that the command will not
take a strong lock instead of stating that it will not wait for one.

On Mon, 2006-07-24 at 11:20 -0400, Rod Taylor wrote:
> > SHARED CREATE INDEX ....
>
> > Comments?
>
> CREATE [UNIQUE] INDEX <foo> [WITH NOLOCK] ON ...
>
>
--

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-24 15:26:04 Re: UPDATE/DELETE XXX WHERE CURRENT OF cursor_name
Previous Message Rod Taylor 2006-07-24 15:20:12 Re: Better name/syntax for "online" index creation