Re: [GENERAL] I can't drop view?! - Mailing list pgsql-general

From Adriaan Joubert
Subject Re: [GENERAL] I can't drop view?!
Date
Msg-id 36DF7AB5.1B188E24@albourne.com
Whole thread Raw
In response to Re: [GENERAL] I can't drop view?!  ("Viktor A." <a2891891@smail.Uni-Koeln.DE>)
List pgsql-general
>
> I just DROPped the mentioned VIEWs with the
> DROP TABLE
> Command! DROP VIEW doesn't work... on any of them...
>
> The problem with the view I can't create, because it once had existed
>  still bugs, though.......
>

I had the same problem. I spent a day digging through source code and
the admin tables, and ended up having to dump the data, drop the
database and redo the whole thing from scratch. There does not seem to
be any other way....

Adriaan

pgsql-general by date:

Previous
From: "Gene Selkov Jr."
Date:
Subject: Re: [SQL] FW: indexing functions
Next
From: "Colin Price (EML)"
Date:
Subject: RE: [GENERAL] I can't drop view?!