Add pg_relation_by_filenode(reltbspc, filenode) admin function

Поиск
Список
Период
Сортировка
Now that I proposed a new syscache upthread its easily possible to provide
pg_relation_by_filenode which I wished for multiple times in the past when
looking at filesystem activity and wondering which table does what. You can
sortof get the same result via

SELECT oid FROM (      SELECT oid, pg_relation_filenode(oid::regclass) filenode      FROM pg_class WHERE relkind !=
'v'
) map
WHERE map.filenode = ...;

but thats neither efficient nor obvious.

So, two patches to do this:


Did others need this in the past? I can live with the 2nd patch living in a
private extension somewhere. The first one would also be useful for some
error/debug messages during decoding...

Greetings,

Andres



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
Следующее
От: Andres Freund
Дата:
Сообщение: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs