[ADMIN] information_schema.tables view does not exist

[Lukasz Brodziak]

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.

[Tom Lane]

Post by Lukasz Brodziak
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

[Lukasz Brodziak]

We have a function which checks if certain tables exist in tables view it
simply runs select over the view and if it returns no rows function creates
table. In this case it ends up with the error in subject.
Fortunately I managed to repair the db. PgAdmin did not show the create
script for the view but EMS SQL Manager did so I used it recreate the view.
Now I'm curious why postgres gives the no such file error.

Post by Tom Lane

Post by Lukasz Brodziak
I got a database from client to be migrated from 8.2.4 to 9.0 and I got

an

Post by Lukasz Brodziak
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