Event trigger table rewrite doc missing ALTER MATERIALIZED VIEW case

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Event trigger table rewrite doc missing ALTER MATERIALIZED VIEW case
Date: 2026-10-26 03:52:31
Message-ID: CALdSSPi1EsLjfT-tCD=LOUdog06VVh6xCUHG=hntgFM4wBwA6w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Small documentation omission found while testing event triggers on:
the Event Triggers chapter says in "table_rewrite" section:

The table_rewrite event occurs just before a table is rewritten by
some actions of the commands ALTER TABLE and ALTER TYPE.

but ALTER MATERIALIZED VIEW ... SET ACCESS METHOD also fires
table_rewrite, with TG_TAG = 'ALTER MATERIALIZED VIEW'

Suggested fix:

diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml
--- a/doc/src/sgml/event-trigger.sgml
+++ b/doc/src/sgml/event-trigger.sgml
@@ -150,7 +150,8 @@
<para>
The <literal>table_rewrite</literal> event occurs just before a table is
- rewritten by some actions of the commands <literal>ALTER TABLE</literal>
- and <literal>ALTER TYPE</literal>. While other
+ rewritten by some actions of the commands <literal>ALTER TABLE</literal>,
+ <literal>ALTER MATERIALIZED VIEW</literal> and <literal>ALTER
TYPE</literal>.
+ While other

--
Best regards,
Kirill Reshke

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ZizhuanLiu X-MAN 2026-10-26 03:55:25 Re: Optimize mergejoinscansel() by avoiding redundant computations
Previous Message shihao zhong 2026-10-26 03:45:28 Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed