Re: Incomplete pg_dump operation - Mailing list pgsql-novice

From peter@vfemail.net
Subject Re: Incomplete pg_dump operation
Date
Msg-id 20100207220428.90E98632A14@mail.postgresql.org
Whole thread Raw
In response to Re: Incomplete pg_dump operation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Incomplete pg_dump operation
List pgsql-novice
Yes.  The:

     select * from pg_class where oid = 2196359751;

command returns:

 relname | relnamespace | reltype | relowner | relam | relfilenode | relpages | reltuples | reltoastrelid |
reltoastidxid| relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs
|relhasoids | relhaspkey | relhasrules | relhassubclass | relacl 

---------+--------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
(0 rows)

-------

At 11:29 AM 2/7/2010, Tom Lane wrote:
>peter@vfemail.net writes:
>> I then executed a:
>>     REINDEX TABLE xyz;
>> command -- using the table name pg_dump was complaining about yesterday -- and received this message:
>>     ERROR:  could not open relation with OID 2196359751
>> making reference to the same OID pg_dump complained about yesterday.
>
>Do you get anything from "select * from pg_class where oid = 2196359751;" ?
>
>                        regards, tom lane



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Incomplete pg_dump operation
Next
From: James Long
Date:
Subject: Novice PL/pgSQL question and example