Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Unable to read from a view - Mailing list pgsql-sql

From Gregory Holston
Subject Re: [SQL] Unable to read from a view
Date
Msg-id Pine.SUN.3.91.990225102112.9179B-100000@shell
Whole thread Raw
In response to Re: [SQL] Unable to read from a view  (jwieck@debis.com (Jan Wieck))
List pgsql-sql
Tree view 
>
>     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

pgsql-sql by date:

Previous
From: "Dr. Nisai Wanakule"
Date:
Subject: Re: [SQL] PL/Perl?
Next
From: Michael Davis
Date:
Subject: Foreign Keys