Incorrect grammar on ALTER EVENT TRIGGER

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Incorrect grammar on ALTER EVENT TRIGGER
Дата
Msg-id 0AFB171E-7E78-4A90-A140-46AB270212CA@yesql.se
обсуждение исходный текст
Список 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


Вложения

В списке pgsql-docs по дате отправления:

Предыдущее
От: gparc@free.fr
Дата:
Сообщение: Re: SQL command : ALTER DATABASE OWNER TO
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: SQL command : ALTER DATABASE OWNER TO