Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 66F462E019D
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 09:36:41 -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 88349-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 09:36:40 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by postgresql.org (Postfix) with ESMTP id EA5CE2E0178
	for <pgsql-sql@postgresql.org>; Wed,  6 Feb 2008 09:36:40 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.1/8.14.1) with ESMTP id m16DaZoi006543
	for <pgsql-sql@postgresql.org>; Wed, 6 Feb 2008 09:36:35 -0400 (AST)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.1/8.14.1/Submit) id m16DaLR6006511
	for pgsql-sql@postgresql.org; Wed, 6 Feb 2008 09:36:21 -0400 (AST)
	(envelope-from news)
From: "Sabin Coanda" <sabin.coanda@deuromedia.ro>
X-Newsgroups: pgsql.sql
Subject: undefined relations in pg_locks
Date: Wed, 6 Feb 2008 15:36:26 +0200
Organization: Hub.Org Networking Services
Lines: 15
Message-ID: <focd4k$6bd$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
To: pgsql-sql@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/31
X-Sequence-Number: 30122

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