]> granicus.if.org Git - postgresql/commit
Allow on-the-fly capture of DDL event details
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 11 May 2015 22:14:31 +0000 (19:14 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 11 May 2015 22:14:31 +0000 (19:14 -0300)
commitb488c580aef4e05f39be5daaab6464da5b22a494
tree79e7605ff000293710de977a5389a8fbf615f702
parentfa2642438f189c2b169ace3ac1df19533b9c7781
Allow on-the-fly capture of DDL event details

This feature lets user code inspect and take action on DDL events.
Whenever a ddl_command_end event trigger is installed, DDL actions
executed are saved to a list which can be inspected during execution of
a function attached to ddl_command_end.

The set-returning function pg_event_trigger_ddl_commands can be used to
list actions so captured; it returns data about the type of command
executed, as well as the affected object.  This is sufficient for many
uses of this feature.  For the cases where it is not, we also provide a
"command" column of a new pseudo-type pg_ddl_command, which is a
pointer to a C structure that can be accessed by C code.  The struct
contains all the info necessary to completely inspect and even
reconstruct the executed command.

There is no actual deparse code here; that's expected to come later.
What we have is enough infrastructure that the deparsing can be done in
an external extension.  The intention is that we will add some deparsing
code in a later release, as an in-core extension.

A new test module is included.  It's probably insufficient as is, but it
should be sufficient as a starting point for a more complete and
future-proof approach.

Authors: Álvaro Herrera, with some help from Andres Freund, Ian Barwick,
Abhijit Menon-Sen.

Reviews by Andres Freund, Robert Haas, Amit Kapila, Michael Paquier,
Craig Ringer, David Steele.
Additional input from Chris Browne, Dimitri Fontaine, Stephen Frost,
Petr Jelínek, Tom Lane, Jim Nasby, Steven Singer, Pavel Stěhule.

Based on original work by Dimitri Fontaine, though I didn't use his
code.

Discussion:
  https://www.postgresql.org/message-id/m2txrsdzxa.fsf@2ndQuadrant.fr
  https://www.postgresql.org/message-id/20131108153322.GU5809@eldon.alvh.no-ip.org
  https://www.postgresql.org/message-id/20150215044814.GL3391@alvh.no-ip.org
72 files changed:
doc/src/sgml/event-trigger.sgml
doc/src/sgml/func.sgml
src/backend/catalog/aclchk.c
src/backend/commands/event_trigger.c
src/backend/commands/opclasscmds.c
src/backend/commands/schemacmds.c
src/backend/commands/tablecmds.c
src/backend/commands/tsearchcmds.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/tcop/utility.c
src/backend/utils/adt/format_type.c
src/backend/utils/adt/pseudotypes.c
src/include/catalog/catversion.h
src/include/catalog/opfam_internal.h [new file with mode: 0644]
src/include/catalog/pg_proc.h
src/include/catalog/pg_type.h
src/include/commands/defrem.h
src/include/commands/event_trigger.h
src/include/commands/extension.h
src/include/nodes/parsenodes.h
src/include/tcop/deparse_utility.h [new file with mode: 0644]
src/include/utils/aclchk_internal.h [new file with mode: 0644]
src/include/utils/builtins.h
src/test/modules/Makefile
src/test/modules/test_ddl_deparse/Makefile [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/alter_extension.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/alter_function.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/alter_sequence.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/alter_table.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/alter_type_enum.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/comment_on.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_conversion.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_domain.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_extension.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_function.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_operator.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_rule.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_schema.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_sequence_1.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_table.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_trigger.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_type.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/create_view.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/defprivs.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/matviews.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/opfamily.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/expected/test_ddl_deparse.out [new file with mode: 0644]
src/test/modules/test_ddl_deparse/regress_schedule [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/alter_function.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/alter_sequence.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/alter_table.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/alter_type_enum.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/comment_on.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_conversion.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_domain.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_extension.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_rule.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_schema.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_sequence_1.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_table.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_trigger.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_type.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/create_view.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/defprivs.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/matviews.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/opfamily.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/sql/test_ddl_deparse.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/test_ddl_deparse--1.0.sql [new file with mode: 0644]
src/test/modules/test_ddl_deparse/test_ddl_deparse.c [new file with mode: 0644]
src/test/modules/test_ddl_deparse/test_ddl_deparse.control [new file with mode: 0644]