Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AC3289FB7B2 for ; Fri, 9 Mar 2007 16:48:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 08231-09 for ; Fri, 9 Mar 2007 16:48:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from tinlc.com (unknown [72.18.206.65]) by postgresql.org (Postfix) with ESMTP id BF9A79FB60A for ; Fri, 9 Mar 2007 16:48:11 -0400 (AST) Received: from [127.0.0.1] (helo=localhost) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1HPm40-0002L1-LX; Fri, 09 Mar 2007 15:51:44 -0500 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <20070309191112.GB2153@bams.ccf.swri.edu> Date: Fri, 9 Mar 2007 20:51:44 -0000 X-Mailer: JoyMail 2.01 Message-ID: <5140152e00e28ac90209884943d60d3d@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.143 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/53 X-Sequence-Number: 24877 Hash: RIPEMD160 > > > When I SELECT any records from a certain table ("Acquisitions"), I get: > > > > > acqlibdb=> select * from "Acquisitions"; > > > ERROR: relation "Acquisitions" does not exist ..> > Humm. I don't think so, since I've never altered the search_path > settings, nor used any schema besides public. And I've been working > with this database for 8 months now without ever encountering such an > error. And all of the other tables work just fine. See what this gives you: SELECT nspname, relname, relkind FROM pg_class c, pg_namespace n WHERE c.relnamespace = n.oid AND lower(relname) ~ 'acqu' ORDER BY 2,1,3; - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200703091547 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFF8cfuvJuQZxSWSsgRA0HYAJ0dWE1L3Ewzu8D8pWyJZd8vniw2zgCfaqYZ zCX9tS5iBecoDP7nn5A7Jy0= =0XFc -----END PGP SIGNATURE-----