From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: information_schema.tables view does not exist
Date: Mon, 19 Dec 2011 10:07:38 -0500
Message-ID: <19787.1324307258@sss.pgh.pa.us> (raw)
In-Reply-To: <CAGWYGjXNpO31eOy9OsriXh2F16Q9HN2Cn_Kbffqc6=YtE_iikQ@mail.gmail.com>
References: <CAGWYGjXNpO31eOy9OsriXh2F16Q9HN2Cn_Kbffqc6=YtE_iikQ@mail.gmail.com>
Lukasz Brodziak <lukasz.brodziak@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, lukasz.brodziak@gmail.com
Subject: Re: information_schema.tables view does not exist
In-Reply-To: <19787.1324307258@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox