>>Um, wrong. We don't lock rows for SELECT.
>
> Unless you meant something else? Am I not following you?
I mean row level shared read lock. eg. a lock that says, you can read
but you cannot delete.
It's what postgres needs to alleviate its foreign key trigger deadlock
problems.
Chris