FOR PORTION OF leftovers should fire triggers on the child table

From: Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: FOR PORTION OF leftovers should fire triggers on the child table
Date: 2026-09-04 18:52:20
Message-ID: CA+renyW05mOmgAu3syfZOdaH9Gg6kiFH2YC8s=4_NkqTKQsC2Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Hackers,

Here is a fix for finding D6 from [0].

In 7d13b03 we made a fix to insert temporal leftovers directly into
the child table (under traditional inheritance), but we didn't update
trigger firing, so they were still firing on the parent table. This
commit fixes that, firing triggers on the child. And that means we
need to build a matching transition table.

[0] https://www.postgresql.org/message-id/CA%2BrenyV6QLOJYmLo3gbsg1Y%2BCrho8NqME1jJXgPbO_NgxfBaKQ%40mail.gmail.com

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com

Attachment Content-Type Size
v1-0001-Fire-leftover-INSERT-triggers-on-the-table-the-le.patch text/x-patch 24.9 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2026-09-04 19:02:33 Re: Fix XLogFileReadAnyTLI silently applying divergent WAL from wrong timeline
Previous Message Masahiko Sawada 2026-09-04 18:40:56 Re: REPACK (CONCURRENTLY) fails when table owner lacks CONNECT