Re: could not open relation - why? - Mailing list pgsql-general

From Tom Lane
Subject Re: could not open relation - why?
Date
Msg-id 19590.1154954769@sss.pgh.pa.us
Whole thread Raw
In response to could not open relation - why?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: could not open relation - why?
List pgsql-general
"Harald Armin Massa" <haraldarminmassa@gmail.com> writes:
> within my log there is the following snippet:

> 2006-08-07 13:20:27 LOG:  autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR:  could not open relation with OID 311438
> 2006-08-07 13:21:52 LOG:  autovacuum: processing database "postgres"

The easiest explanation is that someone dropped a table just as
autovacuum was trying to open it.  The above trace suggests that
you're actively changing template1, which is probably not good
practice ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: could not open relation - why?
Next
From: Thor Tall
Date:
Subject: psql internal variables