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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
