Robert Creager <[EMAIL PROTECTED]> writes: >> Could you supply the relation names corresponding to the relation OIDs >> appearing in pg_locks, so we can be sure who's processing what?
> Sure, if you tell me how ;-) I looked at the view definition and that didn't help > me much... select relname from pg_class where oid = 'whatever'; or if you still have the pg_locks data select relname,pg_locks.* from pg_locks,pg_class where pg_class.oid = relation; regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])