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/