Horton

Re: BUG #19380: Transition table in AFTER INSERT trigger misses rows from MERGE when used with INSERT in a CTE

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es
From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: dwwoelfel@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2026-01-24T11:48:41Z
Lists: pgsql-bugs 
On Tue, 20 Jan 2026 at 18:01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Okay, I've now been through it more carefully, and it looks good
> except for these nitpicks (addressed in v2 patch attached):
>

OK, those make sense. Thanks for reviewing.

I've pushed this now. Expecting to have to push updates to
.abi-compliance-history soon.

Regards,
Dean

Commits

  1. Update .abi-compliance-history for change to TransitionCaptureState.

  2. Fix trigger transition table capture for MERGE in CTE queries.