information_schema.tables view does not exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux