create view error???

From: Rynell Wesson <rwesson(at)cs(dot)utexas(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: create view error???
Date: 2000-11-14 12:23:28
Message-ID: Pine.LNX.4.21.0011140617220.27816-100000@isle-of-jura.cs.utexas.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan Bateman 2000-11-14 15:41:16 postgresql on Win 2k??????
Previous Message Hossein S. Zadeh 2000-11-14 01:07:16 Re: slow vacuuming...