Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
Дата
Msg-id 29201.1021049306@sss.pgh.pa.us
обсуждение исходный текст
Ответ на A couple of errors encountered in 7.1.3=>7.2.1-2 data migration  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
Ray Ontko <rayo@ontko.com> writes:
> develop=# select count(*) from temp_event ;
> ERROR:  cannot find attribute 1 of relation temp_event

I'm beginning to think there is something seriously messed up about your
installation.  The simplest theory is that the indexes on pg_attribute
are corrupted.  You could try a query that won't use the indexes, eg

select (select relname from pg_class where oid = attrelid)
from pg_attribute where attnum = 1 order by 1;

and look through the output to see if temp_event and the other broken
table are mentioned.  If so, then the rows are there but the index is
wrong.  You should be able to recover using REINDEX --- read the
reference page for it carefully before executing the recovery procedure!

If that doesn't work, re-initdb and re-importation of your dump would be
a good next step.  Something must have dropped a bit somewhere...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BufferLookup table corrupted