Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id F1171633180 for ; Sat, 10 Apr 2010 01:29:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 56413-02 for ; Sat, 10 Apr 2010 04:29:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 9443A633152 for ; Sat, 10 Apr 2010 01:29:10 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3A4T678021664; Sat, 10 Apr 2010 00:29:06 -0400 (EDT) To: Brian Cox cc: "pgsql-performance@postgresql.org" Subject: Re: "could not open relation..." In-reply-to: <4BBF8357.6010908@ca.com> References: <4BBF8357.6010908@ca.com> Comments: In-reply-to Brian Cox message dated "Fri, 09 Apr 2010 12:43:19 -0700" Date: Sat, 10 Apr 2010 00:29:06 -0400 Message-ID: <21663.1270873746@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.171 tagged_above=-10 required=5 tests=AWL=-1.161, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/131 X-Sequence-Number: 38381 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