X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 32C0C30F291
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 23:50:43 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 04180-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 20:50:32 -0300 (ADT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 6B7E130F1F7
	for <pgsql-sql@postgresql.org>; Tue, 17 Jun 2003 20:50:32 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5HNoVU6017807;
	Tue, 17 Jun 2003 19:50:32 -0400 (EDT)
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: yet pg_toast reindex 
In-reply-to: <00cf01c33506$feb88f90$0701a8c0@netterm> 
References: <Pine.LNX.4.33.0306170600390.1572-100000@css120.ihs.com>
	<00db01c334cb$4d731920$0701a8c0@netterm>
	<12765.1055861751@sss.pgh.pa.us>
	<00cf01c33506$feb88f90$0701a8c0@netterm>
Comments: In-reply-to "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
	message dated "Tue, 17 Jun 2003 16:31:04 -0300"
Date: Tue, 17 Jun 2003 19:50:31 -0400
Message-ID: <17806.1055893831@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200306/210
X-Sequence-Number: 13968

"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> Sorry about this sucks thread but now i´v got following error
> ERROR: relation "pg_toast_26474986" is of type "t"

You may have to use REINDEX INDEX (on the index not the toast table of
course) to get it to work in older versions.  REINDEX didn't use to
think it could work on toast tables.

			regards, tom lane