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(at)rinet(dot)ru ***
------------------------------------------------------------------------