deadlock detected messages

Started by David Goodenoughover 19 years ago2 messagesgeneral
Jump to latest
#1David Goodenough
david.goodenough@btconnect.com

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

#2Chris Mair
chrisnospam@1006.org
In reply to: David Goodenough (#1)
Re: deadlock detected messages

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.