From: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
To: pgsql-sql@postgresql.org
Subject: Re: yet pg_toast reindex
Date: Wed, 18 Jun 2003 09:39:08 -0300
Message-ID: <00a001c33596$9cc1a9d0$0701a8c0@netterm> (raw)
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>
<17806.1055893831@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eric@vianet-express.com.br
Subject: Re: yet pg_toast reindex
In-Reply-To: <00a001c33596$9cc1a9d0$0701a8c0@netterm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox