| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Rows with exclusive lock |
| Date: | 2006-07-22 14:38:58 |
| Message-ID: | Pine.LNX.4.64.0607221135470.17932@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
---------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-07-22 14:42:18 | Re: Rows with exclusive lock |
| Previous Message | Richard Jones | 2006-07-22 13:32:57 | Referential integrity (foreign keys) across multiple tables |