* Martin Marques: >> That's what SELECT FOR UPDATE does. > > Hi Alvaro, > > After the SELECT FOR UPDATE other transactions can still see the > locked rows. I want a read/write lock, so no one can access does rows.
You should probably run the other transactions at SERIALIZABLE level. I suppose this will make them wait for the completion of the update. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
