| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
| Cc: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: DROP VIEWS |
| Date: | 2001-10-13 02:31:53 |
| Message-ID: | Pine.BSF.4.21.0110121931280.99565-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-10-13 02:33:46 | Re: Indexes |
| Previous Message | Oleg Lebedev | 2001-10-13 01:57:34 | DROP VIEWS |