Re: [SQL] Unable to read from a view

From: Gregory Holston <holston(at)itd(dot)nrl(dot)navy(dot)mil>
To: Jan Wieck <jwieck(at)debis(dot)com>
Cc: jwieck(at)debis(dot)com, pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Unable to read from a view
Date: 1999-02-25 15:21:44
Message-ID: Pine.SUN.3.91.990225102112.9179B-100000@shell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> Don't know if it really works for you (I can't reproduce the
> problem shortly), but try this as postgres superuser:
>
> DELETE FROM pg_rewrite WHERE rulename = '_RETpubsearch';
> DROP TABLE pubsearch;

It worked thanks a lot!!!

-Greg

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Davis 1999-02-25 15:32:20 Foreign Keys
Previous Message Dr. Nisai Wanakule 1999-02-25 14:16:53 Re: [SQL] PL/Perl?