Re: wrong results: merge when not matched by source - Mailing list pgsql-bugs

From Dean Rasheed
Subject Re: wrong results: merge when not matched by source
Date
Msg-id CAEZATCV4vF1vzmVhRnSo8XJ31-yt3+D5xuXcpfostTK-FSU13w@mail.gmail.com
Whole thread
In response to Re: wrong results: merge when not matched by source  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: wrong results: merge when not matched by source
List pgsql-bugs
On Fri, 18 Sept 2026, 12:03 Dean Rasheed, <dean.a.rasheed@gmail.com> wrote:

That fix looks good to me. Nice and simple.

Actually, the last part of the new comment is wrong/unnecessary. If it changes matched from true to false, retrying, it will have locked the target tuple, and it can't be concurrently deleted when it retries. It never retries more than once. So the comment can be simplified a bit.

Regards,
Dean

pgsql-bugs by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: wrong results: merge when not matched by source
Next
From: Tender Wang
Date:
Subject: Re: wrong results: merge when not matched by source