Horton

Re: BUG #17800: ON CONFLICT DO UPDATE fails to detect incompatible fields that leads to a server crash

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2023-02-25T21:46:07Z
Lists: pgsql-bugs 
Hi,

On 2023-02-24 09:44:12 -0800, Andres Freund wrote:
> I'd happy if you had a go at it.  I might take a stab at moving the the
> argument evaluation inline, after this goes in.

Turned out to be pretty simple (at least for now, we'll see what I missed):
https://www.postgresql.org/message-id/20230225214401.346ancgjqc3zmvek%40awork3.anarazel.de

Greetings,

Andres Freund

Commits

  1. Fix MULTIEXPR_SUBLINK with partitioned target tables, yet again.

  2. Repair rare failure of MULTIEXPR_SUBLINK subplans in inherited updates.