Thread: pgsql: Support more commands in event triggers

pgsql: Support more commands in event triggers

From
Alvaro Herrera
Date:
Support more commands in event triggers

COMMENT, SECURITY LABEL, and GRANT/REVOKE now also fire
ddl_command_start and ddl_command_end event triggers, when they operate
on database-local objects.

Reviewed-By: Michael Paquier, Andres Freund, Stephen Frost

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/296f3a6053844089bc533630fffafaba8f016384

Modified Files
--------------
doc/src/sgml/event-trigger.sgml      |  125 +++++++++++++++++++++++++++++++++-
src/backend/commands/event_trigger.c |   34 ++++++++-
src/backend/tcop/utility.c           |   64 +++++++++++++----
src/include/commands/event_trigger.h |    1 +
4 files changed, 207 insertions(+), 17 deletions(-)


Re: pgsql: Support more commands in event triggers

From
Fabien COELHO
Date:
> doc/src/sgml/event-trigger.sgml      |  125 +++++++++++++++++++++++++++++++++-

While reading the documentation, it occured to me that the first sentence
of the first subsection lacks a reference to "table_rewrite", see attached
very minor suggestion.

BTW, I'll try to send a "check" script.

--
Fabien.

Attachment

Re: pgsql: Support more commands in event triggers

From
Fabien COELHO
Date:
Hello Alvaro,

I have submitted a small patch to improve tests on event triggers,
including tests for GRANT/REVOKE/COMMENT:

     https://commitfest.postgresql.org/5/179/

--
Fabien.