Thread: I can't drop view?!

I can't drop view?!

From
"V. A."
Date:
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