pgsql: Fix oversight in FindTriggerIncompatibleWithInheritance. - Mailing list pgsql-committers

From Etsuro Fujita
Subject pgsql: Fix oversight in FindTriggerIncompatibleWithInheritance.
Date
Msg-id E1ukId3-001MQv-2t@gemulon.postgresql.org
Whole thread Raw
List 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.fujita@gmail.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(+)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: pg_upgrade: Add missing newline in output, another one
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Fix incorrect lack of Datum conversion in _int_matchsel()