Re: ESTERROR

Looks like my problem is back again today:

ERROR:  relation with OID 76511 does not exist

What's the best way to track down this issue? Also, when I see these
errors there's usually no active query, maybe stat's collector or some
other internal process is looking for a table that doesn't exist anymore?

-Mike



Michael Guerin wrote:
>
>> "EST" looks suspiciously like "Eastern Standard Time," considering
>> that the timezone in your email is -0500.  Does a timestamp immediately
>> precede the above string?  Have you set log_line_prefix without a
>> trailing space?
>>
>
> Yep, its East Std. Time.. I've already awarded myself the DA award for
> today... :(
>
>> As for "relation with OID X does not exist," see if the FAQ's
>> explanation fits your situation:
>>
>> http://www.postgresql.org/docs/faqs.FAQ.html#item4.19
>>
> No, no temp tables are used in any of our functions.  It seems to have
> gone away after I stopped and restarted the database.
> Here's a little background on the db that was having this problem.
> The database is not typical, its created using files and tables are
> basically dropped and recreated every time one of the source files
> change.  Temp tables are created and populated then within a
> transaction the live table is dropped and the tmp table is renamed to
> be the live table.
> thanks
> -mike
>