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

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

pgsql-novice by date

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

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