Nathan Wilhelmi <wilhelmi(at)ucar(dot)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