>>>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