pg_locks relation cant be found in pg_class

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg_locks relation cant be found in pg_class
Date: 2019-07-24 09:15:05
Message-ID: CA+t6e1kvxSngFpHbr1VbzsxUh1SyG6MhsoiAsBCgE1wN9DDozw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey,
I'm trying to map an oid of relations in pg_lock to a relation name with
the following query :
select locktype,relname,database,mode,pid,granted from pg_locks,pg_class
where locktype='relation' and pg_locks.relation=pg_class.oid;

However, I'm getting only relations of system catalogs and not other
relations.. pg_locks contains rows for many relations, for example :
postgres=# select relation,count(*) from pg_locks where locktype='relation'
group by relation order by count desc;
relation | count
----------+-------
16531 | 4
320587 | 3
16535 | 3
320585 | 3

but in the result of my first query I dont get the relation name. For
example :
postgres=# select count(*) from pg_class where oid in (16531,320587,16535);
count
-------
0

any idea ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Swanand Kshirsagar 2019-07-24 13:03:46 Restrict permissions on schema to hide pl/pgsql code
Previous Message Suresh Seema 2019-07-24 07:09:42 Re: pguint Installation error in PostgreSQL server version 11.2