pgsql: Syntax support and documentation for event triggers. - Mailing list pgsql-committers

Syntax support and documentation for event triggers.

They don't actually do anything yet; that will get fixed in a
follow-on commit.  But this gets the basic infrastructure in place,
including CREATE/ALTER/DROP EVENT TRIGGER; support for COMMENT,
SECURITY LABEL, and ALTER EXTENSION .. ADD/DROP EVENT TRIGGER;
pg_dump and psql support; and documentation for the anticipated
initial feature set.

Dimitri Fontaine, with review and a bunch of additional hacking by me.
Thom Brown extensively reviewed earlier versions of this patch set,
but there's not a whole lot of that code left in this commit, as it
turns out.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/3855968f328918b6cd1401dd11d109d471a54d40

Modified Files
--------------
doc/src/sgml/catalogs.sgml                  |   87 +++++
doc/src/sgml/event-trigger.sgml             |  415 +++++++++++++++++++++
doc/src/sgml/filelist.sgml                  |    1 +
doc/src/sgml/postgres.sgml                  |    1 +
doc/src/sgml/ref/allfiles.sgml              |    3 +
doc/src/sgml/ref/alter_event_trigger.sgml   |  105 ++++++
doc/src/sgml/ref/alter_extension.sgml       |    1 +
doc/src/sgml/ref/comment.sgml               |    1 +
doc/src/sgml/ref/create_event_trigger.sgml  |  162 ++++++++
doc/src/sgml/ref/drop_event_trigger.sgml    |  113 ++++++
doc/src/sgml/ref/psql-ref.sgml              |   14 +
doc/src/sgml/ref/security_label.sgml        |    1 +
doc/src/sgml/reference.sgml                 |    3 +
src/backend/catalog/Makefile                |    2 +-
src/backend/catalog/aclchk.c                |   40 ++
src/backend/catalog/dependency.c            |   27 ++-
src/backend/catalog/objectaddress.c         |   22 ++
src/backend/catalog/pg_shdepend.c           |    6 +
src/backend/catalog/system_views.sql        |   13 +
src/backend/commands/Makefile               |    4 +-
src/backend/commands/alter.c                |    9 +
src/backend/commands/dropcmds.c             |    4 +
src/backend/commands/event_trigger.c        |  539 +++++++++++++++++++++++++++
src/backend/nodes/copyfuncs.c               |   30 ++
src/backend/nodes/equalfuncs.c              |   26 ++
src/backend/parser/gram.y                   |  113 ++++++-
src/backend/tcop/utility.c                  |   33 ++
src/backend/utils/adt/pseudotypes.c         |   27 ++
src/backend/utils/cache/syscache.c          |   23 ++
src/bin/pg_dump/common.c                    |    5 +
src/bin/pg_dump/pg_dump.c                   |  150 ++++++++
src/bin/pg_dump/pg_dump.h                   |   16 +-
src/bin/pg_dump/pg_dump_sort.c              |   16 +-
src/bin/psql/command.c                      |    3 +
src/bin/psql/describe.c                     |   61 +++
src/bin/psql/describe.h                     |    3 +
src/bin/psql/help.c                         |    1 +
src/include/catalog/catversion.h            |    2 +-
src/include/catalog/dependency.h            |    1 +
src/include/catalog/indexing.h              |    5 +
src/include/catalog/pg_event_trigger.h      |   63 +++
src/include/catalog/pg_proc.h               |    4 +
src/include/catalog/pg_type.h               |    2 +
src/include/commands/event_trigger.h        |   28 ++
src/include/nodes/nodes.h                   |    2 +
src/include/nodes/parsenodes.h              |   27 ++
src/include/parser/kwlist.h                 |    1 +
src/include/utils/acl.h                     |    2 +
src/include/utils/builtins.h                |    2 +
src/include/utils/syscache.h                |    2 +
src/test/regress/expected/event_trigger.out |   90 +++++
src/test/regress/expected/rules.out         |    6 +-
src/test/regress/expected/sanity_check.out  |    3 +-
src/test/regress/parallel_schedule          |    2 +
src/test/regress/serial_schedule            |    1 +
src/test/regress/sql/event_trigger.sql      |   93 +++++
56 files changed, 2398 insertions(+), 18 deletions(-)