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