From: | "V(dot) A(dot)" <a2891891(at)smail(dot)Uni-Koeln(dot)DE> |
---|---|
To: | "Postgres-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | I can't drop view?! |
Date: | 1999-03-04 13:15:40 |
Message-ID: | 00ae01be6641$1a3f0e40$0200a8c0@Tischrechner.rrz.uni-koeln.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1999-03-04 14:05:03 | Re: [HACKERS] PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error |
Previous Message | David R. Favor | 1999-03-04 11:31:04 | PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error |