[GENERAL] table locking and SELECT FOR UPDATE

[Joseph Shraibman]

How come when a share lock is held and update can't be done on the 
table, but a SELECT FOR UPDATE can be done?  I can't SELECT FOR UPDATE 
the same row in two transactions, but I can SELECT FOR UPDATE a row that 
I will won't be able to update because the other table is held in a 
SHARE lock.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq