Re: Deferred constraints and locks...

Tom Lane wrote:

>Nathan Wilhelmi <wilhelmi@ucar.edu> writes:
>
>
>>Hello - Trying to track down a lock contention problem, I have a process
>>that does a series of select / insert operations. At some point the
>>process grabs a series of RowExclusiveLock(s) and has the obvious effect
>>of stalling other processes. I logged all the statements and don't see
>>any for update or explicit lock statements.
>>
>>
>
>Insert statements would naturally take RowExclusiveLock, but that
>doesn't block other DML operations.  So the question is what *else*
>are you doing?
>
>            regards, tom lane
>
>
Good question, is there anyway to figure out which rows are locked?

-Nate