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

From Alvaro Herrera
Subject Re: Rows with exclusive lock
Date
Msg-id 20060722144218.GH5125@surnet.cl
Whole thread Raw
In response to Rows with exclusive lock  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: Rows with exclusive lock  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-sql
Martin Marques escribió:
> Is it posible to get an exclusive (read/write) lock on certain rows? I 
> don't want to block the whole table, only certain rows, but I want it to 
> be a read/write lock.

That's what SELECT FOR UPDATE does.

> AFAIK SELECT FOR UPDATE doesn't help with this.

Why?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-sql by date:

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