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