Re: "could not open relation..."

From: Tom Lane
Subject: Re: "could not open relation..."
Date: ,
Msg-id: 21663.1270873746@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: "could not open relation..."  (Brian Cox)
List: pgsql-performance

Tree view

"could not open relation..."  (Brian Cox, )
 Re: "could not open relation..."  (Tom Lane, )
 Re: "could not open relation..."  (Brian Cox, )
  Re: "could not open relation..."  (Tom Lane, )

Brian Cox <> writes:
> I saw this in the postgres log. Anyone know what would cause this?
> Thanks, Brian

> postgres 8.3.5 on RHEL4 update 6

> [3358-cemdb-admin-2010-04-09 04:00:19.029 PDT]ERROR:  could not open
> relation with OID 170592

Seems a bit off-topic for pgsql-performance, but anyway: the main
known cause for that is if one of the tables used in the query got
dropped (by another session) just after the query started.  Could
that have happened to you?

            regards, tom lane


pgsql-performance by date:

From: Scott Marlowe
Date:
Subject: Re: [PERFORM] About “context-switching issue on Xeon” test case ?
From: Krzysztof Kardas
Date:
Subject: Re: PostgreSQL with Zabbix - problem of newbe