From: Brian Cox <brian.cox@ca.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: "could not open relation..."
Date: Fri, 09 Apr 2010 12:43:19 -0700
Message-ID: <4BBF8357.6010908@ca.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: brian.cox@ca.com
Subject: Re: "could not open relation..."
In-Reply-To: <4BBF8357.6010908@ca.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox