From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Scott Chapman <scott_list(at)mischko(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Relation "reviews" with OID 16856 no longer exists |
Date: | 2003-02-27 09:05:53 |
Message-ID: | 20030227090552.GD16796@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.
From | Date | Subject | |
---|---|---|---|
Next Message | Patrik Kudo | 2003-02-27 10:30:47 | Re: index usage (and foreign keys/triggers) |
Previous Message | Shridhar Daithankar | 2003-02-27 07:07:28 | Re: 7.4? |