From: Jan Wieck <JanWieck@Yahoo.com>
To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: see toast table
Date: Sat, 24 May 2003 17:11:51 -0400
Message-ID: <3ECFE017.7060800@Yahoo.com> (raw)
References: <001101c31fb8$ebdb30c0$0701a8c0@netterm>
<3ECE195A.7060209@Yahoo.com>
<004901c3212e$8919fda0$0701a8c0@netterm>
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@Yahoo.com>
> To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
> Cc: <pgsql-sql@postgresql.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@Yahoo.com #
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.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@Yahoo.com #
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: JanWieck@Yahoo.com, eric@vianet-express.com.br
Subject: Re: see toast table
In-Reply-To: <3ECFE017.7060800@Yahoo.com>
* 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