From: | peter(at)vfemail(dot)net |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Incomplete pg_dump operation |
Date: | 2010-02-07 21:57:28 |
Message-ID: | 20100207220428.90E98632A14@mail.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)vfemail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | James Long | 2010-02-08 01:33:29 | Novice PL/pgSQL question and example |
Previous Message | Tom Lane | 2010-02-07 16:29:51 | Re: Incomplete pg_dump operation |