Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT Generating Row Exclusive Locks? - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT Generating Row Exclusive Locks?
Date
Msg-id 6876.1133414679@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT Generating Row Exclusive Locks?  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: SELECT Generating Row Exclusive Locks?
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: Re: postgres log file
Next
From: Bruno Wolff III
Date:
Subject: Re: Finding uniques across a big join