SOLVED: cannot access or delete view

[Holger Marzen]

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 <ho****@marzen. de>
To: pg***********@p ostgresql.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_benutze r,
l.kennwort as v_login_kennwor t
from
laufwerk l,
laufwerk_in_gru ppe lg,
benutzer_in_gru ppe 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?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org