Re: "could not open relation..."

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us]" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: "could not open relation..."
Date: 2010-04-11 04:02:37
Message-ID: 4BC149DD.1090908@ca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 04/10/2010 12:29 AM, Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2010-04-11 12:44:25 Re: Some question
Previous Message Greg Smith 2010-04-11 02:22:50 Re: About “context-switching issue on Xeon” test case ？