Search Postgresql Archives

Re: deadlock detected messages

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux