cannot access or delete view

From: Holger Marzen <holger(at)marzen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: cannot access or delete view
Date: 2004-07-12 13:03:14
Message-ID: Pine.LNX.4.60.0407121458130.22174@bluebell.marzen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2004-07-12 13:08:13 SOLVED: cannot access or delete view
Previous Message Magnus Hagander 2004-07-12 12:20:11 Re: win32 port