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