Re: wrong results: merge when not matched by source

From: Tender Wang <tndrwang(at)gmail(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: wrong results: merge when not matched by source
Date: 2026-09-20 01:41:44
Message-ID: CAHewXN=xnNWnR37A1C91ayCjmH1a2WH3uB0zrXvDozwTuNVRyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> 于2026年9月19日周六 16:43写道:
> OK, here is an update doing that.
>
> Since a new v19 beta is about to be released, I'll hold off on pushing
> this until later next week.

Thanks for working on this.

By the way, since you are looking at MERGE, I wonder if you might also
have a chance to look at the other issue reported earlier involving a
prepared MERGE in [1].
I am not even sure whether the reported behavior should be considered a bug.
I proposed a tentative fix in that thread, but I would appreciate your
thoughts on both the expected behavior and the proposed approach.

[1] https://www.postgresql.org/message-id/19689-0a1b106035cd8a5b%40postgresql.org

--
Thanks,
Tender Wang

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pritt Balagopal 2026-09-20 11:12:54 Re: BUG #19562: pgcli packaged by the PostgreSQL Yum Repository:ModuleNotFoundError: No module named 'pgspecial'
Previous Message PG Bug reporting form 2026-09-20 00:21:01 BUG #19706: Documentation: Missing step in the instructions for restoring sample dvdrental DB from dvdrental.zip