"Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> 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