Re: Incomplete pg_dump operation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Incomplete pg_dump operation
Дата
Msg-id 24710.1265609989@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Incomplete pg_dump operation  (peter@vfemail.net)
Ответы Re: Incomplete pg_dump operation  (peter@vfemail.net)
Список pgsql-novice
peter@vfemail.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Mary Anderson
Дата:
Сообщение: Newbie question about blobs and bytea
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Novice PL/pgSQL question and example