Re: BUG #18526: 'UPDATE' inconsistency using index scan with 'NOT EXIST' after upgrading to PostgreSQL 16

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Feliphe Pozzer <feliphepozzer(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18526: 'UPDATE' inconsistency using index scan with 'NOT EXIST' after upgrading to PostgreSQL 16
Date: 2024-07-01 02:49:14
Message-ID: CAMbWs4-OAa85a==FFFFx6btA23u7EE=Tgci4hLGzDtZjaQNBHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Jun 29, 2024 at 4:38 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Feliphe Pozzer <feliphepozzer(at)gmail(dot)com> writes:
> > Hello Tom, I applied the patch you suggested, and it appears that the issue
> > has been resolved.
>
> Thanks for following up! We should have an official fix in August's
> minor releases.

Thanks for the report and the investigation!

Thanks
Richard

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2024-07-01 02:55:23 Re: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join
Previous Message David Rowley 2024-07-01 00:12:48 Re: BUG #18484: "Cannot enlarge string buffer" during parallel execution of prepared statement/partitioning