Re: file in data doesn't correspond to any oid in pg_class? - Mailing list pgsql-general

From Tom Lane
Subject Re: file in data doesn't correspond to any oid in pg_class?
Date
Msg-id 16081.1048800301@sss.pgh.pa.us
Whole thread Raw
In response to file in data doesn't correspond to any oid in pg_class?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> How do I track down what relation is stored in a given file in data?

You should be searching the relfilenode column, not the oid column.
Also, are you certain you are looking in the right database?

            regards, tom lane


pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: About OIDs
Next
From: Alvaro Herrera
Date:
Subject: Re: About OIDs