information_schema.tables view does not exist

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: information_schema.tables view does not exist
Date: 2011-12-19 10:41:24
Message-ID: CAGWYGjXNpO31eOy9OsriXh2F16Q9HN2Cn_Kbffqc6=YtE_iikQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message K P Manoj 2011-12-19 14:40:53 Re: Index error on recovery
Previous Message Myint 2011-12-19 04:03:24 Re: Regarding postgres 9.1 with Redhat Linux