Re: table locking

Hi Tom,

Sorry I tihnk I misunderstood your post the first time round :(

SHARE ROW EXCLUSIVE MODE works just fine :))  Thanks very much :)

Regards

Shane


On Monday 18 Feb 2002 3:42 pm, Tom Lane wrote:
> I think you want just LOCK TABLE tab IN SHARE ROW EXCLUSIVE MODE
> or LOCK TABLE tab IN EXCLUSIVE MODE.  The latter would lock out
> SELECT FOR UPDATE, the former wouldn't.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly