SOLVED: cannot access or delete view
От | Holger Marzen |
---|---|
Тема | SOLVED: cannot access or delete view |
Дата | |
Msg-id | Pine.LNX.4.60.0407121507001.22730@bluebell.marzen.de обсуждение исходный текст |
Список | pgsql-general |
I had tomatoes on my eyes. I wrote laufverke but meant laufwerke. Sorry. ---------- Forwarded message ---------- Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST) From: Holger Marzen <holger@marzen.de> To: pgsql-general@postgresql.org Subject: cannot access or delete view Hi all, I installed PostgreSQL 7.4.2 from backports.org and all went fine. Then I did as user postgres: create view v_laufverke as select distinct bg.mandant as v_mandant, bg.benutzer as v_benutzer, l.laufwerk as v_laufwerk, l.pfad as v_pfad, l.benutzer as v_login_benutzer, l.kennwort as v_login_kennwort from laufwerk l, laufwerk_in_gruppe lg, benutzer_in_gruppe bg where l.mandant = lg.mandant and l.mandant = bg.mandant and l.laufwerk = lg.laufwerk and lg.gruppe = bg.gruppe and bg.mandant = lower('201') and bg.benutzer = lower('Marzen'); But "select * from v_laufwerke" gives "FEHLER: Relation >>v_laufwerke<< existiert nicht" (ERROR: Relation v_laufwerke doesn't exist). Dropping fails as well although it seems to be there: login=# \dv List of relations Schema | Name | Type | Owner --------+-------------+------+---------- public | v_laufverke | view | postgres (1 row) \dv v_laufwerke returns "No matching relations found." (in english). Did I miss something?
В списке pgsql-general по дате отправления: