DROP VIEWS - Mailing list pgsql-sql

From Oleg Lebedev
Subject DROP VIEWS
Date
Msg-id 3BC79F8E.6FE94199@waterford.org
Whole thread Raw
Responses Re: DROP VIEWS  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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




pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: MEDIAN as custom aggregate?
Next
From: "Aasmund Midttun Godal"
Date:
Subject: Indexes