Postgres Pro
Downloads
Home   >   mailing lists

Re: information_schema.tables view does not exist - Mailing list pgsql-admin

From Tom Lane
Subject Re: information_schema.tables view does not exist
Date
Msg-id 19787.1324307258@sss.pgh.pa.us
Whole thread Raw
In response to information_schema.tables view does not exist  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Responses Re: information_schema.tables view does not exist  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: K P Manoj
Date:
Subject: Re: Index error on recovery
Next
From: Mario Splivalo
Date:
Subject: Giving postgres roles 'sudo'-like access