Nathan Wilhelmi <wilhelmi@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
