Re: cannot access or delete view - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: cannot access or delete view
Date
Msg-id 20040712175542.GD2428@dcc.uchile.cl
Whole thread Raw
In response to cannot access or delete view  (Holger Marzen <holger@marzen.de>)
List pgsql-general
On Mon, Jul 12, 2004 at 03:03:14PM +0200, Holger Marzen wrote:

> 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)

I see a "v" in the name instead of a "w" ?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)


pgsql-general by date:

Previous
From: Holger Marzen
Date:
Subject: SOLVED: cannot access or delete view
Next
From: "Florian G. Pflug"
Date:
Subject: (Again) Datacorruption using 7.4.2 on XFS/raid1