Re: PANIC in heap_delete during ALTER TABLE - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: PANIC in heap_delete during ALTER TABLE
Date
Msg-id CAH2-Wz=NkOYQkN+LQau_RP=jp+hF5rbCcDOpfh0F+8yOtf+syg@mail.gmail.com
Whole thread Raw
In response to Re: PANIC in heap_delete during ALTER TABLE  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-bugs
On Thu, Sep 22, 2022 at 11:47 AM Jeff Davis <pgsql@j-davis.com> wrote:
> Committed.

My thoughts on the fix (a little belated):

The patch looks very much like it can only affect cases that are going
to crash anyway (by forcing a restart). Plus you're just adding
another reason to restart in heap_delete() -- there were already a few
reasons why that might be necessary. So the fix is very well targeted.
Even when I think about it in the most adversarial/pessimistic way
possible, it's still very difficult to imagine anybody being worse off
than they would have been without the patch. OTOH it's readily
apparent that this fixes a crash.

There are no absolute certainties, but I do feel confident that
committing this fix was the right response, all things considered.

-- 
Peter Geoghegan



pgsql-bugs by date:

Previous
From: Jeff Davis
Date:
Subject: Re: PANIC in heap_delete during ALTER TABLE
Next
From: Fahar Abbas
Date:
Subject: Re: BUG #17621: PostgreSQL 15 Windows installer still downloads Beta 3