Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group