Re: table locking

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: me(at)shanewright(dot)co(dot)uk
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: table locking
Date: 2002-02-18 15:42:56
Message-ID: 11225.1014046976@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shane Wright 2002-02-18 15:46:16 Re: table locking
Previous Message Shane Wright 2002-02-18 15:42:51 Re: table locking