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