Re: undefined relations in pg_locks

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