table locking and SELECT FOR UPDATE

[Joseph Shraibman <jks@xxxxxxxxxxxxxxx>]

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