Postgres Pro
Downloads
Home   >   mailing lists

Re: table locking - Mailing list pgsql-sql

From Tom Lane
Subject Re: table locking
Date
Msg-id 11225.1014046976@sss.pgh.pa.us
Whole thread Raw
In response to Re: table locking  (Shane Wright <me@shanewright.co.uk>)
Responses Re: table locking  (Shane Wright <me@shanewright.co.uk>)
Re: table locking  (Shane Wright <me@shanewright.co.uk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: table locking
Next
From: Shane Wright
Date:
Subject: Re: table locking