Postgres Pro
Downloads
Home   >   mailing lists

create view error??? - Mailing list pgsql-novice

From Rynell Wesson
Subject create view error???
Date
Msg-id Pine.LNX.4.21.0011140627010.27816-100000@isle-of-jura.cs.utexas.edu
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Mauricio Alarcon
Date:
Subject: Replication
Next
From: "Poul L. Christiansen"
Date:
Subject: Re: Replication