Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C3C582E0035 for ; Mon, 7 Apr 2008 11:03:57 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65762-01 for ; Mon, 7 Apr 2008 11:03:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 515512E003C for ; Mon, 7 Apr 2008 11:03:47 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m37E3XtP004726; Mon, 7 Apr 2008 10:03:33 -0400 (EDT) To: "Sabin Coanda" cc: pgsql-sql@postgresql.org Subject: Re: undefined relations in pg_locks In-reply-to: References: Comments: In-reply-to "Sabin Coanda" message dated "Mon, 07 Apr 2008 11:56:35 +0300" Date: Mon, 07 Apr 2008 10:03:33 -0400 Message-ID: <4725.1207577013@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/45 X-Sequence-Number: 30584 "Sabin Coanda" writes: > 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 tables? Are you sure they are in the same database you are working in? If the locktype is "relation" and the database column matches your database's OID, the relation column definitely ought to match some OID in pg_class. It is possible that you can't see the pg_class row because the relation was created in a transaction that hasn't committed yet --- but such an entry could never be a reason for a deadlock, because no other transaction could be trying to lock it. regards, tom lane