Обсуждение: deadlock detected messages

Поиск
Список
Период
Сортировка

deadlock detected messages

От
David Goodenough
Дата:
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

От
Chris Mair
Дата:
> 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.