Re: Wrong varnullingrels for MERGE into a trigger-updatable view

From: Tender Wang <tndrwang(at)gmail(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Wrong varnullingrels for MERGE into a trigger-updatable view
Date: 2026-11-15 02:12:33
Message-ID: CAHewXNk4FUk19U3DBDzNtA8fRNcq+tiSTcWmvcdmcN3t3g_b6Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Dean,

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> 于2026年11月13日周五 23:44写道：
>
> On Fri, 13 Nov 2026 at 13:13, Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> >
> > I found another “wrong varnullingrels” error involving MERGE into a
> > trigger-updatable view:
>
> Ah, yes, well spotted.
>
> The test case can a simplified a little:
>

Thanks for simplifying the test case. I have used that version for
the regression test in the attached v2 patch.

--
Tender Wang

Attachment Content-Type Size
v2-0001-Fix-nullingrels-for-expressions-above-MERGE-joins.patch text/plain 7.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Zsolt Parragi 2026-11-14 23:50:47 Re: two statement_timeout race conditions