Re: [GENERAL] I can't drop view?!

From: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
To: "Viktor A(dot)" <a2891891(at)smail(dot)Uni-Koeln(dot)DE>
Cc: Postgres-General <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] I can't drop view?!
Date: 1999-03-05 06:33:25
Message-ID: 36DF7AB5.1B188E24@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin Price (EML) 1999-03-05 09:53:25 RE: [GENERAL] I can't drop view?!
Previous Message Gene Selkov Jr. 1999-03-05 04:55:31 Re: [SQL] FW: indexing functions