How can I find out what object corresponds to a given OID in the
relation column in the pg_locks table?

Thanks in advance,

Frank


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Frank Kurzawa <fkurzawa (AT) topazsoftware (DOT) com> writes:
Join to pg_class.oid:

select relname from pg_locks, pg_class where relation = pg_class.oid;

or cast it to regclass:

select relation::regclass from pg_locks;

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings