Re: ESTERROR

Is the autovacuum running?
Prolly related tho.

g.-

On 3/15/06, Michael Guerin <guerin(at)rentec(dot)com> wrote:
> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Guido Barosio
-----------------------