Re: First draft of the PG 15 release notes - Mailing list pgsql-hackers

From Amit Langote
Subject Re: First draft of the PG 15 release notes
Date
Msg-id CA+HiwqFcEdbNinfK94aTgBJKmtkYGdtkPnjt3b0fVzKi+WZ+KA@mail.gmail.com
Whole thread Raw
In response to First draft of the PG 15 release notes  (Bruce Momjian <bruce@momjian.us>)
Responses Re: First draft of the PG 15 release notes
List pgsql-hackers
On Wed, May 11, 2022 at 12:44 AM Bruce Momjian <bruce@momjian.us> wrote:
> I have completed the first draft of the PG 15 release notes

Thanks.  Regarding:

<!--
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
2022-03-20 [ba9a7e392] Enforce foreign key correctly during cross-partition upd
-->

<listitem>
<para>
Improve the trigger behavior of updates on partitioned tables that
move rows between partitions (Amit Langote)
</para>

<para>
Previously, such updates fired delete triggers on the source partition
and fired insert triggers on the target partition.  PostgreSQL will
now fire an update trigger on the partition root.  This makes
foreign key behavior more consistent.  ALL TRIGGERS?
</para>
</listitem>

The commit is intended to only change the behavior of RI triggers,
while leaving user-defined triggers firing as before.  I think it
might be a good idea to be specific by wording this, maybe as follows?

Improve the firing of foreign key triggers during cross-partition
updates of partitioned tables (Amit Langote)

Previously, such updates fired delete triggers on the source partition
and insert triggers on the target partition, whereas PostgreSQL will
now fire update triggers on the partitioned table mentioned in the
query, which makes the behavior of foreign keys pointing into that
table more consistent.  Note that other user-defined triggers are
fired as they were before.


--
Thanks, Amit Langote
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: TRAP: FailedAssertion("tabstat->trans == trans", File: "pgstat_relation.c", Line: 508
Next
From: Kyotaro Horiguchi
Date:
Subject: gitmaster access