agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Paul M. Aoki <aoki@postgres.Berkeley.EDU>
To: perera@pollux.cs.uga.edu
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: "define view question" ( Another problem ? )
Date: Mon, 25 Apr 94 17:53:16 -0700
Message-ID: <199404260053.RAA08882@faerie.CS.Berkeley.EDU> (raw)
In-Reply-To: <9404260031.AA11245@pollux.cs.uga.edu>
perera@pollux.cs.uga.edu writes:
> * remove rule demo \g
> Query sent to backend is "remove rule demo "
> WARN:Apr 25 20:26:37:prs2GetRuleEventRel: rule "demo" not found
> * remove view demo \g
> Query sent to backend is "remove view demo "
> WARN:Apr 25 20:26:47:RewriteGetRuleEventRel: class 340384 not found
views are
- a rewrite (not instance) rule -- "define rule" and "remove
rule" default to instance rules
- some other misc. catalog entries that define a fake table
called "demo"
i would guess that in the process of trying to execute other commands
(perhaps "destroy demo") you removed the pg_class entry for "demo".
it's hard to say how to fix it without really knowing exactly what
you've already tried. but
remove rewrite rule _RETdemo
would probably be a good start. if you can't do that, then you
probably did do a "destroy", and you would have to fall back to
delete pg_rewrite where pg_rewrite.rulename = "_RETdemo"
(at least, i hope you did "destroy" instead of randomly removing
pg_class and pg_attribute tuples.)
in any event, remove view is the safe way to do it. i stuck a
man page for it into the 4.2 reference manual so that will go out
with the final release (which will go out when we get solaris
compilers, which will be soon i hope).
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: aoki@postgres.Berkeley.EDU, perera@pollux.cs.uga.edu
Subject: Re: "define view question" ( Another problem ? )
In-Reply-To: <199404260053.RAA08882@faerie.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox