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 ? TIA, Sabin ---------------------------(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