Return-Path: owner-postman 
Delivery-Date: Mon, 25 Apr 94 20:00:04 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA10331 for postgres-redist; Mon, 25 Apr 1994 17:31:43 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404260031.RAA10331@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from pollux.cs.uga.edu (pollux.cs.uga.edu [128.192.4.5]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA10322 for <postgres@postgres.berkeley.edu>; Mon, 25 Apr 1994 17:31:41 -0700
From: perera@pollux.cs.uga.edu
Received: by pollux.cs.uga.edu (4.1/25-eef)
	id AA11245; Mon, 25 Apr 94 20:31:39 EDT
Date: Mon, 25 Apr 94 20:31:39 EDT
Message-Id: <9404260031.AA11245@pollux.cs.uga.edu>
To: postgres@postgres.Berkeley.EDU
Subject: Re: "define view question" ( Another problem ? )
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 25 Apr 94 17:31:42 -0700
Resent-XMts: smtp

Hi:

Thanks to all who gave me "tips", well I  still cant get rid of the
view "demo". However I was able to create another view and delete it
with the command "remove view ..."

I am using postgres 4.1. Here is my output.

-- Niranjan

[pollux] monitor
Welcome to the C POSTGRES terminal monitor

Go 
* remove rule demo \g

Query sent to backend is "remove rule demo "
WARN:Apr 25 20:26:37:prs2GetRuleEventRel: rule "demo" not found

Go 
* remove view demo \g

Query sent to backend is "remove view demo "
WARN:Apr 25 20:26:47:RewriteGetRuleEventRel: class 340384 not found

Go 
* define view demo ( s.sname ) \g

Query sent to backend is "define view demo ( s.sname ) "
WARN:Apr 25 20:27:03:Attempt to insert rule '_RETdemo' failed: already exists

Go 
* \q
I live to serve you.
[pollux]