Postgres Pro
Downloads
Home   >   mailing lists

undefined relations in pg_locks - Mailing list pgsql-sql

From Sabin Coanda
Subject undefined relations in pg_locks
Date
Msg-id focd4k$6bd$1@news.hub.org
Whole thread Raw
Responses Re: undefined relations in pg_locks
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From:
Date:
Subject: Re: Multiple postgresql functions in a single transaction
Next
From: Guillaume Lelarge
Date:
Subject: Re: undefined relations in pg_locks