Re: could not open relation - why?

"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