I can't drop view?! - Mailing list pgsql-general

From V. A.
Subject I can't drop view?!
Date
Msg-id 00ae01be6641$1a3f0e40$0200a8c0@Tischrechner.rrz.uni-koeln.de
Whole thread Raw
List pgsql-general
Hi!

I created a couple of views with the purpose of showing only results of
the current date. By mistake, I used 'current_date' which always keeps
its creation date rather than the date of execution.
Therefor I wanted to drop these views, and redo them with 'date(text
'now')'.

When I tried to drop it:
drop view view_anrufe_gesamt_tn11_1tag

It stated:
ERROR:  RewriteGetRuleEventRel: rule "_RETview_anrufe_gesamt_tn11_1tag" not
found

Needless to say, that it is still there.....
How can I get rid of it? Is there a reason for this? Maybe a workaround?

Another very strange thing is, that a while ago, I tested a little and
created
a view(or funktion....I don't even remember anymore...) called 'test'.
I droped it shortly afterwards..... If I try to do it again, it complains,
that there
still is a relation 'test'

I searched through the pg-questions, but - no results.....

Does anyone know a little about this? It really makes me fuzzy, since
I would hate to delete the whole Database and redo it because of such a
thing....

I'm running Postgres 6.4 on a Linux server....

´Thanks in advanced!

Viktor


pgsql-general by date:

Previous
From: "David R. Favor"
Date:
Subject: PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error