agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: perera@pollux.cs.uga.edu
To: postgres@postgres.Berkeley.EDU
Subject: Re: "define view question" ( Another problem ? )
Date: Mon, 25 Apr 94 20:31:39 EDT
Message-ID: <9404260031.AA11245@pollux.cs.uga.edu> (raw)

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]

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: perera@pollux.cs.uga.edu
  Subject: Re: "define view question" ( Another problem ? )
  In-Reply-To: <9404260031.AA11245@pollux.cs.uga.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