Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6F06F6339FB for ; Fri, 9 Apr 2010 16:44:30 -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 65651-02 for ; Fri, 9 Apr 2010 19:44:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.ca.com (smtp1.ca.com [141.202.248.21]) by mail.postgresql.org (Postfix) with ESMTP id B6E296339EB for ; Fri, 9 Apr 2010 16:44:19 -0300 (ADT) Received: from athena.ca.com ([130.200.164.17]) by smtp1.ca.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 9 Apr 2010 15:44:17 -0400 Message-ID: <4BBF8357.6010908@ca.com> Date: Fri, 09 Apr 2010 12:43:19 -0700 From: Brian Cox User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20091204 Lightning/1.0b1 Thunderbird/3.0 MIME-Version: 1.0 To: "pgsql-performance@postgresql.org" Subject: "could not open relation..." Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 09 Apr 2010 19:44:18.0001 (UTC) FILETIME=[0AC7FC10:01CAD81D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.514 tagged_above=-10 required=5 tests=AWL=0.524, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/125 X-Sequence-Number: 38375 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 [3358-cemdb-admin-2010-04-09 04:00:19.029 PDT]STATEMENT: select lm.ts_login_name,sm.ts_session_id from ts_user_logins_map lm join ts_user_sessions_map sm on sm.ts_user_id=lm.ts_user_id where not sm.ts_soft_delete and not lm.ts_soft_delete and lm.ts_user_id != 1 and lm.ts_app_id in (600000000000000001) order by sm.ts_creation_time