I can't drop view?!

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

Browse pgsql-general by date

  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