Re: PL/pgSQL question about EXCEPTION clause & corrupt records

Поиск
Список
Период
Сортировка
От Nick Renders
Тема Re: PL/pgSQL question about EXCEPTION clause & corrupt records
Дата
Msg-id FD4BE260-D39B-488E-9B27-2C953EEF4CE3@arcict.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL question about EXCEPTION clause & corrupt records  (Jeremy Schneider <schneider@ardentperf.com>)
Список 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 по дате отправления:

Предыдущее
От: "Nick Renders"
Дата:
Сообщение: Re: PL/pgSQL question about EXCEPTION clause & corrupt records
Следующее
От: Jeremy Finzel
Дата:
Сообщение: Cases where alter table set type varchar(longer length) still needstable rewrite