Re: Relation on longer exists error - Mailing list pgsql-general

From Fran Fabrizio
Subject Re: Relation on longer exists error
Date
Msg-id 3CD6DE8A.7060202@mmrd.com
Whole thread Raw
In response to Relation on longer exists error  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Francisco Reyes wrote:

>I have a script that I regularly run. Today when I ran it I got:
>ERROR:  Relation "ystats" with OID 715717097 no longer exists
>
>I did drop/recreate that table today, but what would I be getting this
>error?
>
You answered your own question.  You dropped the table and recreated it,
in the process it gets a new OID.  Any functions/views/etc... declared
using that table are now looking for it at it's old OID "address".  Drop
and recreate anything that was depending on that table.

-Fran


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2
Next
From: Francisco Reyes
Date:
Subject: Problems with list?