From: | Holger Marzen <holger(at)marzen(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SOLVED: cannot access or delete view |
Date: | 2004-07-12 13:08:13 |
Message-ID: | Pine.LNX.4.60.0407121507001.22730@bluebell.marzen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)marzen(dot)de>
To: pgsql-general(at)postgresql(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2004-07-12 17:55:42 | Re: cannot access or delete view |
Previous Message | Holger Marzen | 2004-07-12 13:03:14 | cannot access or delete view |