From: | Etsuro Fujita <efujita(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix oversight in FindTriggerIncompatibleWithInheritance. |
Date: | 2025-08-08 08:39:10 |
Message-ID: | E1ukId3-001MQv-2t@gemulon.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix oversight in FindTriggerIncompatibleWithInheritance.
This function is called from ATExecAttachPartition/ATExecAddInherit,
which prevent tables with row-level triggers with transition tables from
becoming partitions or inheritance children, to check if there is such a
trigger on the given table, but failed to check if a found trigger is
row-level, causing the caller functions to needlessly prevent a table
with only a statement-level trigger with transition tables from becoming
a partition or inheritance child. Repair.
Oversight in commit 501ed02cf.
Author: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAPmGK167mXzwzzmJ_0YZ3EZrbwiCxtM1vogH_8drqsE6PtxRYw%40mail.gmail.com
Backpatch-through: 13
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/e028ce911ad21e23ca39555e01a2d6c41c76aa79
Modified Files
--------------
src/backend/commands/trigger.c | 2 ++
src/test/regress/expected/triggers.out | 8 ++++++++
src/test/regress/sql/triggers.sql | 10 ++++++++++
3 files changed, 20 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2025-08-08 10:17:03 | pgsql: Fix incorrect lack of Datum conversion in _int_matchsel() |
Previous Message | Peter Eisentraut | 2025-08-08 06:52:12 | pgsql: pg_upgrade: Add missing newline in output, another one |