Postgres Pro
Downloads
Home   >   mailing lists

Re: yet pg_toast reindex - Mailing list pgsql-sql

From Tom Lane
Subject Re: yet pg_toast reindex
Date
Msg-id 17806.1055893831@sss.pgh.pa.us
Whole thread Raw
In response to Re: yet pg_toast reindex  ("Eric Anderson Vianet SAO" <eric@vianet-express.com.br>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: weigelt@metux.de
Date:
Subject: Re: [ADMIN] Can the frontend get notifications from the postgres server?
Next
From: "Rudi Starcevic"
Date:
Subject: Text insert max. size.