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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to