information_schema.tables view does not exist

Поиск
Список
Период
Сортировка
От Lukasz Brodziak
Тема information_schema.tables view does not exist
Дата
Msg-id CAGWYGjXNpO31eOy9OsriXh2F16Q9HN2Cn_Kbffqc6=YtE_iikQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: information_schema.tables view does not exist
Список pgsql-admin
Hello,

I got a database from client to be migrated from 8.2.4 to 9.0 and I got an error ERROR:  could not open relation 1663/206914/10780: No such file or directory.
When I checked pg_class for the oid it occured to be information_schema.tables view. Is there anyway of restoring the view? pgAdmin sees the view in the information schema but any select on the view results in the error message. PG 8.2.4 is running on windows.
Thank You in advance for any help.
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"

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

Предыдущее
От: "Myint"
Дата:
Сообщение: Re: Regarding postgres 9.1 with Redhat Linux
Следующее
От: K P Manoj
Дата:
Сообщение: Re: Index error on recovery