Re: information_schema.tables view does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: information_schema.tables view does not exist
Date: 2011-12-19 15:07:38
Message-ID: 19787.1324307258@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Toland 2011-12-19 16:15:49 PG export/import encoding issue
Previous Message K P Manoj 2011-12-19 14:40:53 Re: Index error on recovery