Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 080542E0072 for ; Thu, 22 May 2008 14:58: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 24347-10 for ; Thu, 22 May 2008 14:58:03 -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 D35682E0073 for ; Thu, 22 May 2008 14:58:04 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JzF36-0000br-NS; Thu, 22 May 2008 19:57:56 +0200 Date: Thu, 22 May 2008 19:57:56 +0200 From: hubert depesz lubaczewski To: Carol Walter Cc: "Tomeh, Husam" , pgsql-admin@postgresql.org Subject: Re: Index problem... Message-ID: <20080522175756.GA2266@depesz.com> Reply-To: depesz@depesz.com References: <473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu> <76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <76ECE23E-2F14-44C4-80F9-259581AF48E3@indiana.edu> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/188 X-Sequence-Number: 29272 On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote: > When I ran the query you specified I got relname of "pg_toast_16429. > When I ran the REINDEX TABLE pg_toast_16429 the system responds that > relation "pg_toast_16429" does not exist. I think it should be pg_toast.pg_toast_16429 so: REINDEX TABLE pg_toast.pg_toast_16429; check relnamespace in pg_class for this table, and check it against pg_namespace to be sure. depesz