> 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match