Thread: deadlock detected messages

deadlock detected messages

From
David Goodenough
Date:
I have a process that is hitting deadlocks.  The message I get talks about
relation and database numbers, not names.  How do I map the numbers back
into names?

David

Re: deadlock detected messages

From
Chris Mair
Date:
> I have a process that is hitting deadlocks.  The message I get talks about
> relation and database numbers, not names.  How do I map the numbers back
> into names?

Hi,
you need to query the catalog:

  -- relations like tables:
  select oid, relname from pg_class;
  -- databases:
  select oid, datname from pg_database;

Bye,
Chris.