From: Brian Cox <brian.cox@ca.com>
To: Tom Lane [tgl@sss.pgh.pa.us] <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: "could not open relation..."
Date: Sat, 10 Apr 2010 21:02:37 -0700
Message-ID: <4BC149DD.1090908@ca.com> (raw)
On 04/10/2010 12:29 AM, Tom Lane [tgl@sss.pgh.pa.us] wrote:
> Seems a bit off-topic for pgsql-performance,
What would be the appropriate forum?
> 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?
interesting and possible; but why doesn't locking prevent this?
Brian
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, tgl@sss.pgh.pa.us
Subject: Re: "could not open relation..."
In-Reply-To: <4BC149DD.1090908@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