DROP VIEWS

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: DROP VIEWS
Date: 2001-10-13 01:57:34
Message-ID: 3BC79F8E.6FE94199@waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I am trying to drop a view 'activity_IP' (notice that last two letters
are capitalized), but get an exception saying:
ERROR: view "activity_ip" does not exist
Here, the last two letters are lower-case.
There is an entry in pg_views table for view 'activity_IP', but not for
'activity_ip'.
How can I drop this view?
Thanks,

Oleg

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-10-13 02:31:53 Re: DROP VIEWS
Previous Message Timothy J Hitchens 2001-10-13 01:15:03 GROUPING