Incorrect grammar on ALTER EVENT TRIGGER

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: pgsql-docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Incorrect grammar on ALTER EVENT TRIGGER
Date: 2024-01-24 14:58:19
Message-ID: 0AFB171E-7E78-4A90-A140-46AB270212CA@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Attachment Content-Type Size
alter_evt.diff application/octet-stream 670 bytes

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2024-01-24 15:35:10 Re: SQL command : ALTER DATABASE OWNER TO
Previous Message gparc 2024-01-24 14:40:20 Re: SQL command : ALTER DATABASE OWNER TO