Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs
Date
Msg-id 29350.1347834932@sss.pgh.pa.us
Whole thread Raw
In response to [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Andres Freund <andres@2ndquadrant.com> writes:
> This requires the previously added RELFILENODE syscache.

[ raised eyebrow... ]  There's a RELFILENODE syscache?  I don't see one,
and I doubt it would work given that the contents of
pg_class.relfilenode aren't unique (the zero entries are the problem).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: too much pgbench init output
Next
From: Andres Freund
Date:
Subject: Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs