Re: Deferred constraints and locks...

Tom Lane wrote:

>Nathan Wilhelmi  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