Postgres Pro
Downloads
Home   >   mailing lists

Relation "reviews" with OID 16856 no longer exists - Mailing list pgsql-general

From Scott Chapman
Subject Relation "reviews" with OID 16856 no longer exists
Date
Msg-id 200302261204.52599.scott_list@mischko.com
Whole thread Raw
Responses Re: Relation "reviews" with OID 16856 no longer exists
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: rserv replication error
Next
From: Steve Crawford
Date:
Subject: Re: WITHOUT OIDS