Re: Deferred constraints and locks...

Nathan Wilhelmi <wilhelmi@ucar.edu> writes:
> Tom Lane wrote:
>> Insert statements would naturally take RowExclusiveLock, but that
>> doesn't block other DML operations.  So the question is what *else*
>> are you doing?

> Good question, is there anyway to figure out which rows are locked?

RowExclusiveLock is a table-level lock, not a lock on a specific row.
See
http://www.postgresql.org/docs/8.2/static/explicit-locking.html

            regards, tom lane