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.