Re: yet pg_toast reindex

which index? could you help me again?

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
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>
Sent: Tuesday, June 17, 2003 8:50 PM
Subject: Re: [SQL] yet pg_toast reindex

> "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html