Re: create view error???

On Tue, 14 Nov 2000, Rynell Wesson wrote:

RW> OS:  Linux 2.2.16
RW> DB:  postgresql-7.0.2
RW>
RW> Why can't I create views?  I get the following errors.  What do I need to
RW> do to properly create this file-- pg_rewrite_rulename_index?
RW>
RW> fakedb=# create view foo as
RW> fakedb-# select * from person;
RW> NOTICE:  mdopen: couldn't open pg_rewrite_rulename_index: No such file or
RW> directory
RW> NOTICE:  mdopen: couldn't open pg_rewrite_rulename_index: No such file or
RW> directory
RW> ERROR:  cannot open relation pg_rewrite_rulename_index

As for me, it seems like an error in system tables. Did you try
vacuuming? Does it return any errors?

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------