Sabin Coanda wrote:
Hi there,
I have a procedure where a dead-lock occurs, and I'm trying to find the
tables involved in the lock.
Unfortunatelly, I don't find the related objects of the oids of "relation"
field. Also all the fields "classid" and "objid" are null.
May I suppose there were references to temporary objects ?
However, how cand I get the related objects involved in this lock ?
Maybe they're not objects of the database you're connected to. You need
to check the "database" column of pg_locks.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
