From: Guillaume Lelarge <guillaume@lelarge.info>
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: undefined relations in pg_locks
Date: Wed, 06 Feb 2008 15:01:43 +0100
Message-ID: <47A9BDC7.8090000@lelarge.info> (raw)
In-Reply-To: <focd4k$6bd$1@news.hub.org>
References: <focd4k$6bd$1@news.hub.org>
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.orghttp://dalibo.com
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: guillaume@lelarge.info, sabin.coanda@deuromedia.ro
Subject: Re: undefined relations in pg_locks
In-Reply-To: <47A9BDC7.8090000@lelarge.info>
* 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