Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx> writes: > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
