Brian Cox <brian.cox@ca.com> 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