Re: yet pg_toast reindex

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: yet pg_toast reindex
Date: 2003-06-17 23:50:31
Message-ID: 17806.1055893831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br> writes:
> Sorry about this sucks thread but now iv 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-06-18 12:02:04 Text insert max. size.
Previous Message Michael A Nachbaur 2003-06-17 23:34:15 Re: Blobs with perl