ERROR: cache lookup failed for type 0

Поиск
Список
Период
Сортировка
От Michael Harris \(BR/EPA\)
Тема ERROR: cache lookup failed for type 0
Дата
Msg-id E5F4C5A18CAB7A4DA23080DE9CE8158603E678CB@eaubrmw001.eapac.ericsson.se
обсуждение исходный текст
Ответы Re: ERROR: cache lookup failed for type 0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

Am not sure if this is something we've done wrong or maybe a bug.

Whenever any kind of query is done on the table below, this is the
result:

ispdb_vxe=> select * from pm.carrier_on_13642;
ERROR:  cache lookup failed for type 0

I first noticed it when I noticed that the regular backups were failing
- pg_dump gives the same output and stops.

I have tried
1. postgresql restart
2. vacuum full on the table
3. reindex of the table

I am using Postgres 8.2.3 running on Centos Linux 4.4.

Is there anything I can do to recover this table?

Is there any danger in dropping the table if it cannot be recreated?

Should this be reported as a bug? (although I have no clue as to how it
got into this state).

Regards,
Mike

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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: index vs. seq scan choice?
Следующее
От: PFC
Дата:
Сообщение: Re: index vs. seq scan choice?