summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian2025-06-07 15:25:17 +0000
committerBruce Momjian2025-06-07 15:25:17 +0000
commit73e26cbeb5927053eea4e209e5eda34a30c353f1 (patch)
tree2f9b98698475dc93c98b15c2a2ccccc9273d648b /doc/src
parent37e5f0b61fa8aad82a0b06438ed95c282ace994a (diff)
doc PG 18 relnotes: add AFTER trigger user change item
Reported-by: Noah Misch Discussion: https://postgr.es/m/20250603172123.5f.nmisch@google.com
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/release-18.sgml16
1 files changed, 16 insertions, 0 deletions
diff --git a/doc/src/sgml/release-18.sgml b/doc/src/sgml/release-18.sgml
index 268fa88cbe0..c5e60f88fdf 100644
--- a/doc/src/sgml/release-18.sgml
+++ b/doc/src/sgml/release-18.sgml
@@ -158,6 +158,22 @@ Previously ALTER TABLE SET [UN]LOGGED did nothing, and the creation of an unlogg
</listitem>
<!--
+Author: Tom Lane <tgl@sss.pgh.pa.us>
+2025-01-23 [01463e1cc] Ensure that AFTER triggers run as the instigating user.
+-->
+
+<listitem>
+<para>
+Execute AFTER triggers as the role that was active when trigger events were queued (Laurenz Albe)
+</para>
+
+<para>
+Previously such triggers were run as the role that was active at trigger execution time (e.g., at COMMIT). This is significant for cases where the role is changed between queue time and
+transaction commit.
+</para>
+</listitem>
+
+<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-09-12 [fefa76f70] Remove old RULE privilege completely.
-->