Обсуждение: undefined relations in pg_locks
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
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