Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 90CD1476850 for ; Fri, 10 May 2002 13:29:40 -0400 (EDT) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by postgresql.org (Postfix) with ESMTP id 43337476905 for ; Fri, 10 May 2002 13:26:17 -0400 (EDT) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id MAA11282; Fri, 10 May 2002 12:26:16 -0500 X-Authentication-Warning: shire.ontko.com: Host bilbo.ontko.com [199.164.165.101] claimed to be nick Reply-To: From: "Nick Fankhauser" To: "Tom Lane" , "Ray Ontko" Cc: "pgsql-admin" Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration Date: Fri, 10 May 2002 12:24:52 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <29201.1021049306@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200205/89 X-Sequence-Number: 4264 Tom- Thanks! your diagnosis was correct & the repair worked. -Nick & Ray > I'm beginning to think there is something seriously messed up about your > installation. The simplest theory is that the indexes on pg_attribute > are corrupted. ... > You should be able to recover using REINDEX