pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedinformation_schema.tables view does not exist
3+ messages / 2 participants
[nested] [flat]
* information_schema.tables view does not exist
@ 2011-12-19 10:41 Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-12-19 15:07 ` Re: information_schema.tables view does not exist Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Lukasz Brodziak @ 2011-12-19 10:41 UTC (permalink / raw)
To: pgsql-admin
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"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: information_schema.tables view does not exist
2011-12-19 10:41 information_schema.tables view does not exist Lukasz Brodziak <lukasz.brodziak@gmail.com>
@ 2011-12-19 15:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-12-19 22:01 ` Re: information_schema.tables view does not exist Lukasz Brodziak <lukasz.brodziak@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2011-12-19 15:07 UTC (permalink / raw)
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: information_schema.tables view does not exist
2011-12-19 10:41 information_schema.tables view does not exist Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-12-19 15:07 ` Re: information_schema.tables view does not exist Tom Lane <tgl@sss.pgh.pa.us>
@ 2011-12-19 22:01 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Lukasz Brodziak @ 2011-12-19 22:01 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
We have a function which checks if certain tables exist in tables view it
simply runs select over the view and if it returns no rows function creates
table. In this case it ends up with the error in subject.
Fortunately I managed to repair the db. PgAdmin did not show the create
script for the view but EMS SQL Manager did so I used it recreate the view.
Now I'm curious why postgres gives the no such file error.
19-12-2011 16:07 użytkownik "Tom Lane" <tgl@sss.pgh.pa.us> napisał:
> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-12-19 22:01 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-19 10:41 information_schema.tables view does not exist Lukasz Brodziak <lukasz.brodziak@gmail.com>
2011-12-19 15:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-12-19 22:01 ` Lukasz Brodziak <lukasz.brodziak@gmail.com>
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