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?
