Postgres Pro
Downloads
Home   >   mailing lists

Re: missing chunk number 0 for toast value - Mailing list pgsql-general

From Tom Lane
Subject Re: missing chunk number 0 for toast value
Date
Msg-id 2925.1114641645@sss.pgh.pa.us
Whole thread Raw
In response to Re: missing chunk number 0 for toast value  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: missing chunk number 0 for toast value  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pgsql@bluepolka.net> writes:
> On Wednesday April 27 2005 3:55 pm, Tom Lane wrote:
>> Have you tried REINDEXing the toast table in question?

> Not yet.  Any way to repair it without blocking concurrent
> access?

Unlikely.  But the lock will only affect operations that need to touch
toasted field values.

            regards, tom lane

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: missing chunk number 0 for toast value
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: restarting after power outage