aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2022-03-09 14:59:08 +0900
committerMichael Paquier <michael@paquier.xyz>2022-03-09 14:59:08 +0900
commite3df32bbc38bc4a20092ea18b482b81119fa72dd (patch)
treebfe86901a2ffc9a0cdc39efeaa6408196c418a13
parent7687ca996e558d95e68d2d0d70fed22a6317ba78 (diff)
downloadpostgresql-e3df32bbc38bc4a20092ea18b482b81119fa72dd.tar.gz
postgresql-e3df32bbc38bc4a20092ea18b482b81119fa72dd.zip
doc: Add ALTER/DROP ROUTINE to the event trigger matrix
ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https://postgr.es/m/164647533363.646.5802968483136493025@wrigleys.postgresql.org Backpatch-through: 11
-rw-r--r--doc/src/sgml/event-trigger.sgml16
1 files changed, 16 insertions, 0 deletions
diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml
index 60366a950ec..9c66f97b0f6 100644
--- a/doc/src/sgml/event-trigger.sgml
+++ b/doc/src/sgml/event-trigger.sgml
@@ -294,6 +294,14 @@
<entry align="left"></entry>
</row>
<row>
+ <entry align="left"><literal>ALTER ROUTINE</literal></entry>
+ <entry align="center"><literal>X</literal></entry>
+ <entry align="center"><literal>X</literal></entry>
+ <entry align="center"><literal>-</literal></entry>
+ <entry align="center"><literal>-</literal></entry>
+ <entry align="left"></entry>
+ </row>
+ <row>
<entry align="left"><literal>ALTER SCHEMA</literal></entry>
<entry align="center"><literal>X</literal></entry>
<entry align="center"><literal>X</literal></entry>
@@ -854,6 +862,14 @@
<entry align="left"></entry>
</row>
<row>
+ <entry align="left"><literal>DROP ROUTINE</literal></entry>
+ <entry align="center"><literal>X</literal></entry>
+ <entry align="center"><literal>X</literal></entry>
+ <entry align="center"><literal>X</literal></entry>
+ <entry align="center"><literal>-</literal></entry>
+ <entry align="left"></entry>
+ </row>
+ <row>
<entry align="left"><literal>DROP RULE</literal></entry>
<entry align="center"><literal>X</literal></entry>
<entry align="center"><literal>X</literal></entry>