Re: deadlock detected messages - Mailing list pgsql-general

From Chris Mair
Subject Re: deadlock detected messages
Date
Msg-id 20061029142952.6c5feeea.chrisnospam@1006.org
Whole thread Raw
In response to deadlock detected messages  (David Goodenough <david.goodenough@btconnect.com>)
List pgsql-general
> 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.

pgsql-general by date:

Previous
From: David Goodenough
Date:
Subject: deadlock detected messages
Next
From: Robert Treat
Date:
Subject: Re: Replicating changes