Rows with exclusive lock - Mailing list pgsql-sql

From Martin Marques
Subject Rows with exclusive lock
Date
Msg-id Pine.LNX.4.64.0607221135470.17932@bugs.unl.edu.ar
Whole thread Raw
Responses Re: Rows with exclusive lock
List pgsql-sql
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.

AFAIK SELECT FOR UPDATE doesn't help with this.

Do I have to go for another aproche?

-- 21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,    del Litoral             |   Administrador
---------------------------------------------------------

pgsql-sql by date:

Previous
From: Richard Jones
Date:
Subject: Referential integrity (foreign keys) across multiple tables
Next
From: Alvaro Herrera
Date:
Subject: Re: Rows with exclusive lock