Re: BUG #5646: missing chunk number 0 for toast

Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010:
> "missing chunk number" <chand.vizag@gmail.com> wrote:
>
> > when i run my table in editor i faced this below error.
> > Ex: select * from ad_role
> >
> > ERROR:  missing chunk number 0 for toast value 525559 in
> > pg_toast_325765

> > How can i solve this error.Can u guide me.
>
> This is database corruption and extremely unlikely to be a bug in
> the current maintenance release of 8.3.

Actually, we seem to get this particular report so often that I have my
doubts about it not being a bug.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support