Postgres Pro
Downloads
Home   >   mailing lists

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

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

Previous
From: "Myint"
Date:
Subject: Re: Regarding postgres 9.1 with Redhat Linux
Next
From: K P Manoj
Date:
Subject: Re: Index error on recovery