Re: file in data doesn't correspond to any oid in pg_class?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: file in data doesn't correspond to any oid in pg_class?
Date: 2003-03-27 21:25:01
Message-ID: 16081.1048800301@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Ellis 2003-03-27 21:27:42 Re: PostgreSQL + IDS load/latency help
Previous Message Haroldo Stenger 2003-03-27 21:15:27 Re: [HACKERS] Solution to UPDATE...INSERT problem