Re: see toast table

From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
To: "Jan Wieck" <JanWieck(at)Yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: see toast table
Date: 2003-05-23 13:23:44
Message-ID: 004901c3212e$8919fda0$0701a8c0@netterm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

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 #

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Young 2003-05-23 13:40:04 Re: language "plpgsql" does not exist
Previous Message Jan Wieck 2003-05-23 12:51:38 Re: see toast table