| 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
| 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 |