corruption - toasted table

From: "Silvela, Jaime \(Exchange\)" <JSilvela(at)Bear(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: corruption - toasted table
Date: 2006-08-10 13:24:03
Message-ID: 6D6734D7CD866145AE87A2D5D88830A9022829F7@whexchmb14.bsna.bsroot.bear.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think this cropped up before, but can't find it.

I've run into a problem in which I get "Missing chunk number 0 for toast
value 642223827"

I've tried reindexing the table and restarting the server, but the
problem persists.

I located an archive

"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."

Can someone point me to some relevant FAQ, email etc?

Thanks

Jaime

Attachment Content-Type Size
Disclaimer.txt text/plain 965 bytes

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-08-10 13:28:19 Re: Accessing Database Data from C Function
Previous Message Walid Haider 2006-08-10 13:10:00 Unable to connect to PostgreSQL 8 from PGAdmin III