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 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
