Re: deadlock detected messages

From: Chris Mair <chrisnospam(at)1006(dot)org>
To: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: deadlock detected messages
Date: 2006-10-29 13:29:52
Message-ID: 20061029142952.6c5feeea.chrisnospam@1006.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2006-10-29 14:17:15 Re: Replicating changes
Previous Message David Goodenough 2006-10-29 12:12:33 deadlock detected messages