Re: see toast table

Eric Anderson Vianet SAO wrote:
> because the following error:
>
> ´missing chunk number 0 for toast value 32067496´
>
> I get ir when I try ´vacuum -e -v -z -e´ or a simple pg_dump.
>
> I would like to know what is this value. And how could i fix it.

You have probably a corrupted toast index on a table. Try to reindex it
and if that doesn't help hunt down the damaged main row and update it's
toasted value with something fresh (there have been enough discussions
about it, you should find how to do that in the mailing list archives.

These discussions will also point out that you probably have some bad
memory and/or other non trustworthy piece of hardware including the
tools you should use to identify the damage.

Jan

>
> tnx.
>
> Eric Anderson Martins Miranda
> Net Admin @ Via Net SAO
> ----- Original Message -----
> From: "Jan Wieck" <JanWieck(at)Yahoo(dot)com>
> To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
> Cc: <pgsql-sql(at)postgresql(dot)org>
> Sent: Friday, May 23, 2003 9:51 AM
> Subject: Re: [SQL] see toast table
>
>
>
>>Eric Anderson Vianet SAO wrote:
>>
>>>How coul i see a toast table.
>>>
>>>i can´t visualise it at pgadmin.
>>
>>I was wondering what you expect to see then? They are a technical
>>implementation detail within the storage management.
>>
>>
>>Jan
>>
>>--
>>#======================================================================#
>># It's easier to get forgiveness for being wrong than for being right. #
>># Let's break this rule - forgive me. #
>>#================================================== JanWieck(at)Yahoo(dot)com #
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #