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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
