From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-sql@postgresql.org
Subject: undefined relations in pg_locks
Date: Mon, 7 Apr 2008 11:56:35 +0300
Message-ID: <ftcnjo$931$1@news.hub.org> (raw)
Hi there,
Sorry I repeat a problem which concerned me since two months, but I got no
answer. It's not clear for me whether it is trivial or without a solution. I
promisse not to repeat it in the future if I will give no answer this time
too.
So, I'm working with "PostgreSQL 8.2.3 on i686-redhat-linux-gnu, compiled by
GCC gcc (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)";
I have a procedure where a dead-lock occurs, and I'm trying to find the
tables involved in the lock.
A little description of how my procedure works maybe helps. So I have a loop
where I call a second procedure with exception trapping. At its turn, it
calls a third procedure. I guess an exception may occur in the third
procedure, where I use a temporary table. When an exception occurs, I guess
my temporary table table is not dropped, and this may lock the process when
another call try to create that temporary table again. Could be this
scenario what there happens to me ?
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?
However, how cand I get the related objects involved in this lock, by other
way than analyse deeply in the code ?
TIA,
Sabin
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: sabin.coanda@deuromedia.ro
Subject: Re: undefined relations in pg_locks
In-Reply-To: <ftcnjo$931$1@news.hub.org>
* 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