How about SELECT ... FOR UPDATE?
No, because users cannot read the locked row in that case.
I just tested it (within transactions) and it appeared that I could still view the rows selected for update.
Ah, true. My mistake. OK, well you can do it in postgres then...
Chris
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]