Re: PL/pgSQL question about EXCEPTION clause & corrupt records - Mailing list pgsql-general

From Nick Renders
Subject Re: PL/pgSQL question about EXCEPTION clause & corrupt records
Date
Msg-id FD4BE260-D39B-488E-9B27-2C953EEF4CE3@arcict.com
Whole thread Raw
In response to Re: PL/pgSQL question about EXCEPTION clause & corrupt records  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-general
Hi Jeremy,

This happend on PostgreSQL v9.6 which crashed 2 weeks ago.
Since then we have upgraded and restored our server, but my example is 
from the older, corrupt database.

Nick


On 15 Feb 2020, at 5:30, Jeremy Schneider wrote:

>> On Feb 14, 2020, at 04:39, Nick Renders <postgres@arcict.com> wrote:
>>
>> I get the following message:
>>
>>   ERROR:  missing chunk number 0 for toast value 8289525 in 
>> pg_toast_5572299
>
> What version of PostgreSQL are you running? I’ve seen this a number 
> of times the past couple years; curious if the lurking bug is still 
> observed in latest versions.
>
> -Jeremy
>
> Sent from my TI-83



pgsql-general by date:

Previous
From: "Nick Renders"
Date:
Subject: Re: PL/pgSQL question about EXCEPTION clause & corrupt records
Next
From: Jeremy Finzel
Date:
Subject: Cases where alter table set type varchar(longer length) still needstable rewrite