cannot access or delete view

Поиск
Список
Период
Сортировка
Искать
От
Holger Marzen
Тема
cannot access or delete view
Дата
Msg-id
Pine.LNX.4.60.0407121458130.22174@bluebell.marzen.de
Список
Дерево обсуждения
cannot access or delete view Holger Marzen <holger@marzen.de>
Re: cannot access or delete view Alvaro Herrera <alvherre@dcc.uchile.cl>
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 по дате отправления
От: Magnus Hagander
Дата:
Сообщение: Re: win32 port
От: Holger Marzen
Дата:
FAQ