Re: yet pg_toast reindex - Mailing list pgsql-sql

From Eric Anderson Vianet SAO
Subject Re: yet pg_toast reindex
Date
Msg-id 00a001c33596$9cc1a9d0$0701a8c0@netterm
Whole thread Raw
In response to Re: select date range?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
which index? could you help me again?

Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, June 17, 2003 8:50 PM
Subject: Re: [SQL] yet pg_toast reindex


> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html



pgsql-sql by date:

Previous
From: "Rudi Starcevic"
Date:
Subject: Text insert max. size.
Next
From: Tm
Date:
Subject: Re: Object-Relational table design question