Re: Rows with exclusive lock - Mailing list pgsql-sql

From Florian Weimer
Subject Re: Rows with exclusive lock
Date
Msg-id 87fygss5lv.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Rows with exclusive lock  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-sql
* Martin Marques:

>> That's what SELECT FOR UPDATE does.
>
> Hi Alvaro,
>
> After the SELECT FOR UPDATE other transactions can still see the
> locked rows. I want a read/write lock, so no one can access does rows.

You should probably run the other transactions at SERIALIZABLE level.
I suppose this will make them wait for the completion of the update.


pgsql-sql by date:

Previous
From: Martin Marques
Date:
Subject: Re: Rows with exclusive lock
Next
From: Alvaro Herrera
Date:
Subject: Re: Rows with exclusive lock