Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2093B2E3456
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 10:01:51 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95167-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 10:01:46 -0400 (AST)
Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192])
	by postgresql.org (Postfix) with ESMTP id A4DA12E343B
	for <pgsql-sql@postgresql.org>; Wed,  6 Feb 2008 10:01:46 -0400 (AST)
Received: from [192.168.10.1]
	(ASte-Genev-Bois-153-1-10-117.w83-112.abo.wanadoo.fr [83.112.72.117])
	by sd-2317.dedibox.fr (Postfix) with ESMTP id 7ED533862;
	Wed,  6 Feb 2008 15:01:44 +0100 (CET)
Message-ID: <47A9BDC7.8090000@lelarge.info>
Date: Wed, 06 Feb 2008 15:01:43 +0100
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.9 (X11/20071112)
MIME-Version: 1.0
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
CC: pgsql-sql@postgresql.org
Subject: Re: undefined relations in pg_locks
References: <focd4k$6bd$1@news.hub.org>
In-Reply-To: <focd4k$6bd$1@news.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/32
X-Sequence-Number: 30123

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