Re: Incomplete pg_dump operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter(at)vfemail(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Incomplete pg_dump operation
Date: 2010-02-08 06:19:49
Message-ID: 24710.1265609989@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

peter(at)vfemail(dot)net writes:
> At 11:29 AM 2/7/2010, Tom Lane wrote:
>> Do you get anything from "select * from pg_class where oid = 2196359751;" ?

> Yes. The:
> select * from pg_class where oid = 2196359751;
> command returns [ nothing ]

OK, well that explains why it can't open such a relation ;-). The next
question is why is it trying to. My first guess is that there is a
dangling link in pg_index, ie you once had an index with such an OID
but something happened to it. Please try

select * from pg_index where indexrelid = 2196359751;

and if that gets a hit, then select the pg_class row with the OID
shown as indrelid.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-02-08 06:51:16 Re: Novice PL/pgSQL question and example
Previous Message Mary Anderson 2010-02-08 04:51:31 Newbie question about blobs and bytea