You'll need to double quote the name, "activity_IP"
On Fri, 12 Oct 2001, Oleg Lebedev wrote:
> 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 ar
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 c
