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