Re: Relation "reviews" with OID 16856 no longer exists

You have to recreate the view.

On Wed, Feb 26, 2003 at 12:04:52PM -0800, Scott Chapman wrote:
> I recently dropped and recreated the table reviews and the view review_status
> and now I get this:
>
> SELECT review_num from review_status WHERE date_closed IS NULL
> Relation "reviews" with OID 16856 no longer exists
>
> I tried running a vacuumdb -f on the database and restarted it and I still get
> this.
>
> How do I fix this?
>
> Cordially,
> Scott
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.