From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: undefined relations in pg_locks
Date: Mon, 07 Apr 2008 10:03:33 -0400
Message-ID: <4725.1207577013@sss.pgh.pa.us> (raw)
In-Reply-To: <ftcnjo$931$1@news.hub.org>
References: <ftcnjo$931$1@news.hub.org>
"Sabin Coanda" <sabin.coanda@deuromedia.ro> 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
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: tgl@sss.pgh.pa.us, sabin.coanda@deuromedia.ro
Subject: Re: undefined relations in pg_locks
In-Reply-To: <4725.1207577013@sss.pgh.pa.us>
* 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