Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 239BF632B3D for ; Sun, 11 Apr 2010 01:03:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05935-01 for ; Sun, 11 Apr 2010 04:03:37 +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 A50E26324D8 for ; Sun, 11 Apr 2010 01:03:38 -0300 (ADT) Received: from athena.ca.com ([130.200.164.17]) by smtp1.ca.com with Microsoft SMTPSVC(6.0.3790.3959); Sun, 11 Apr 2010 00:03:36 -0400 Message-ID: <4BC149DD.1090908@ca.com> Date: Sat, 10 Apr 2010 21:02:37 -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: "Tom Lane [tgl@sss.pgh.pa.us]" CC: "pgsql-performance@postgresql.org" Subject: Re: "could not open relation..." Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 11 Apr 2010 04:03:37.0051 (UTC) FILETIME=[F62DFAB0:01CAD92B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.01 tagged_above=-10 required=5 tests=T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/137 X-Sequence-Number: 38387 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