| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Zhijie Hou <houzhijie22(at)gmail(dot)com>, Takeshi Ideriha <iderihatakeshi(at)gmail(dot)com>, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, alpkeles99(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction |
| Date: | 2026-10-23 01:45:00 |
| Message-ID: | CAGRkXqTqpsK2Bwq+xD10EAAy1PFCm6brZRC6eEHeSfC_1pUKUA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
Sorry for the slow reply. This turned out a bit more complex than I
expected, and I was busy with some personal stuff yesterday.
On Fri, Oct 23, 2026 at 08:42:14AM +0900, Michael Paquier wrote:
> How does the attached look to you?
Looks good to me. It fixes the report and your pg_statistic case,
and the test fails without the fix.
I think Manu's change for the second spot should go in too, then
both cases in this thread are fixed. I have an isolation test for
this case if that helps.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| cluster-aborted-subxact-update.spec | application/octet-stream | 877 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-10-23 02:01:29 | Re: BUG #19775: Incremental backup without data checksums restores a stale visibility map page after VACUUM truncati |
| Previous Message | shihao zhong | 2026-10-23 01:17:59 | Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a |