Re: information_schema.tables view does not exist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: information_schema.tables view does not exist
Дата
Msg-id 19787.1324307258@sss.pgh.pa.us
обсуждение исходный текст
Ответ на information_schema.tables view does not exist  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Ответы Re: information_schema.tables view does not exist  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Список pgsql-admin
Lukasz Brodziak <lukasz.brodziak@gmail.com> writes:
> 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?

Um ... that's a view, so it's entirely expected that there would not be
any underlying file for it.

What exactly did you do to get that error message?

            regards, tom lane

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

Предыдущее
От: K P Manoj
Дата:
Сообщение: Re: Index error on recovery
Следующее
От: Mario Splivalo
Дата:
Сообщение: Giving postgres roles 'sudo'-like access