I can't drop view?!
От | V. A. |
---|---|
Тема | I can't drop view?! |
Дата | |
Msg-id | 00ae01be6641$1a3f0e40$0200a8c0@Tischrechner.rrz.uni-koeln.de обсуждение исходный текст |
Список | 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 по дате отправления: