Horton

Re: BUG #18502: Upsert on view returns 42P10 error when condition is an expression

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: 王 海 <michael.wanghai.a@outlook.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Geoghegan <pg@bowt.ie>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2024-06-12T02:18:27Z
Lists: pgsql-bugs 
On Tue, Jun 11, 2024 at 7:11 PM 王 海 <michael.wanghai.a@outlook.com> wrote:

> Thanks for the analysis. May I ask how long will it cost normally for such
> bug fix being released since I'm new to the community? And will it be back
> port to PG 12?
>
>
August according to the published roadmap:

https://www.postgresql.org/developer/roadmap/

And yes this one was back-patched to all supported versions which includes
v12 - though its time is up this year once v17 is released.

https://www.postgresql.org/support/versioning/

David J.

Commits

  1. Fix infer_arbiter_indexes() to not assume resultRelation is 1.