Incorrect grammar on ALTER EVENT TRIGGER
Daniel Gustafsson <daniel@yesql.se>
From: Daniel Gustafsson <daniel@yesql.se>
To: pgsql-docs <pgsql-docs@lists.postgresql.org>
Date: 2024-01-24T14:58:19Z
Lists: pgsql-docs
Attachments
- alter_evt.diff (application/octet-stream) patch
The ALTER EVENT TRIGGER .. page has an extra TRIGGER in the parameters section
for ENABLE/DISABLE parameters which isn't supported in the grammar:
https://www.postgresql.org/docs/devel/sql-altereventtrigger.html
postgres=# alter event trigger on_login_trigger disable trigger;
ERROR: syntax error at or near "trigger"
LINE 1: alter event trigger on_login_trigger disable trigger;
^
postgres=# alter event trigger on_login_trigger enable trigger;
ERROR: syntax error at or near "trigger"
LINE 1: alter event trigger on_login_trigger enable trigger;
^
postgres=# alter event trigger on_login_trigger enable always trigger;
ERROR: syntax error at or near "trigger"
LINE 1: alter event trigger on_login_trigger enable always trigger;
^
The attached trivial patch removes the extra keyword, which needs to be
backpatched all the way down.
--
Daniel Gustafsson
Commits
-
doc: remove incorrect grammar for ALTER EVENT TRIGGER
- c1b0d757afaa 14.11 landed
- a0cffcfffd11 13.14 landed
- 7743046b7557 16.2 landed
- 76fd779dbdd5 15.6 landed
- 43eb5c6a479c 12.18 landed
- 16a80e8912bb 17.0 landed