pgsql: Make new event trigger facility actually do something.

Make new event trigger facility actually do something.

Commit 3855968f328918b6cd1401dd11d109d471a54d40 added syntax, pg_dump,
psql support, and documentation, but the triggers didn't actually fire.
With this commit, they now do. This is still a pretty basic facility
overall because event triggers do not get a whole lot of information
about what the user is trying to do unless you write them in C; and
there's still no option to fire them anywhere except at the very
beginning of the execution sequence, but it's better than nothing,
and a good building block for future work.

Along the way, add a regression test for ALTER LARGE OBJECT, since
testing of event triggers reveals that we haven't got one.

Dimitri Fontaine and Robert Haas

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/3a0e4d36ebd7f477822d5bae41ba121a40d22ccc

Modified Files
--------------
contrib/pg_stat_statements/pg_stat_statements.c | 17 +-
doc/src/sgml/plpgsql.sgml | 69 +++++-
doc/src/sgml/ref/create_event_trigger.sgml | 6 -
src/backend/commands/event_trigger.c | 337 +++++++++++++++++-----
src/backend/commands/extension.c | 4 +-
src/backend/commands/schemacmds.c | 4 +-
src/backend/commands/trigger.c | 2 +-
src/backend/executor/functions.c | 4 +-
src/backend/executor/spi.c | 4 +-
src/backend/tcop/pquery.c | 5 +-
src/backend/tcop/utility.c | 197 +++++++++++---
src/backend/tsearch/ts_utils.c | 10 +-
src/backend/utils/cache/Makefile | 4 +-
src/backend/utils/cache/evtcache.c | 242 ++++++++++++++++
src/include/commands/event_trigger.h | 18 ++
src/include/nodes/nodes.h | 1 +
src/include/port.h | 1 +
src/include/tcop/utility.h | 20 +-
src/include/utils/evtcache.h | 34 +++
src/pl/plpgsql/src/pl_comp.c | 54 +++-
src/pl/plpgsql/src/pl_exec.c | 93 +++++++
src/pl/plpgsql/src/pl_handler.c | 23 ++-
src/pl/plpgsql/src/plpgsql.h | 15 +-
src/port/qsort.c | 9 +
src/test/regress/expected/event_trigger.out | 38 ++-
src/test/regress/input/largeobject.source | 16 +
src/test/regress/output/largeobject.source | 20 ++
src/test/regress/sql/event_trigger.sql | 39 ++-
28 files changed, 1088 insertions(+), 198 deletions(-)