"Thomas F. O'Connell" <tfo@sitening.com> writes:
> I guess I'm still somewhat puzzled by the original statement of the
> question, then. Why does that particular view of locks occasionally
> tie a SELECT to a granted Row Exclusive lock?
You sure it's not left over from an update command earlier in the
same transaction?
regards, tom lane