Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D658A2E004A for ; Thu, 22 May 2008 17:15:37 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18619-10 for ; Thu, 22 May 2008 17:15:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from depesz.com (depesz.com [88.198.37.40]) by developer.postgresql.org (Postfix) with ESMTP id 02E3F2E0037 for ; Thu, 22 May 2008 17:15:30 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JzHCC-0002kM-7a; Thu, 22 May 2008 22:15:28 +0200 Date: Thu, 22 May 2008 22:15:28 +0200 From: hubert depesz lubaczewski To: Carol Walter Cc: pgsql-admin@postgresql.org Subject: Re: Index problem... Message-ID: <20080522201528.GA10450@depesz.com> Reply-To: depesz@depesz.com References: <473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu> <76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu> <20080522175756.GA2266@depesz.com> <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <3BFEEECD-CEC5-42C6-B9C2-8249ACEFCA0F@indiana.edu> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/190 X-Sequence-Number: 29274 On Thu, May 22, 2008 at 03:41:38PM -0400, Carol Walter wrote: > This gives the same error. I can select columns from the table > although select * gets the error. I tried making a copy of the > "maps" table using CREATE TABLE new table name (all columns) AS > SELECT all columns FROM maps; This also gave me the same error. well. i think that it's time to move the PGDATA someplace else, initdb, and load backup. depesz