| From: | Tender Wang <tndrwang(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Cc: | Gowtham Reddy <gowthamdoma18(at)gmail(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
| Subject: | Re: BUG #19802: MERGE into a partitioned table fails with "SubPlan found with no parent plan" |
| Date: | 2026-11-03 13:00:38 |
| Message-ID: | CAHewXNmwJFrtkhwUK456aRU4LMD0i1XZPmfaZkcy0ObFvt+_LA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Gowtham Reddy <gowthamdoma18(at)gmail(dot)com> 于2026年10月29日周四 09:27写道：
>
> Hi,
>
> Thanks for the quick analysis and the patch.
>
> I applied the one-line change you described (passing &mtstate->ps to
> ExecBuildUpdateProjection() for the partition MERGE UPDATE action) on
> master at 4848fd675. The reproducer from my report now succeeds, and a
> MERGE that takes the UPDATE path with the subquery in SET updates the
> row correctly.
Thanks for testing the patch and confirming that it fixes the problem.
I am CC'ing Dean, who has worked on related MERGE executor code, in case
he has any comments on the proposed fix.
--
Thanks,
Tender Wang
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2026-11-03 13:39:02 | Re: BUG #19594: to_char/jsonpath format cache serves a format tree parsed in the wrong strict-mode |
| Previous Message | Daniel Gustafsson | 2026-11-03 12:53:07 | Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) |