>>Um, wrong. We don't lock rows for SELECT.
>
> No, but Chris is correct that we could do with having some kind of
> shared lock facility at the row level.
Out of interest, what is it about this particular task that's so hard?
(Not that I could code it myself). But surely you can use the same sort
of thing as the FOR UPDATE code path?
Chris