From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-sql@postgresql.org
Subject: undefined relations in pg_locks
Date: Wed, 6 Feb 2008 15:36:26 +0200
Message-ID: <focd4k$6bd$1@news.hub.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sabin.coanda@deuromedia.ro
Subject: Re: undefined relations in pg_locks
In-Reply-To: <focd4k$6bd$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox