On Nov 30, 2005, at 11:24 PM, Tom Lane wrote:
> "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?
Pretty sure, unless the query I posted earlier can cause the display
of leftover commands...
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)