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"