From 841a5150c575ccd89e4b03aec66eeeefb21f3cbe Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Mon, 21 Jan 2013 18:00:24 -0500 Subject: Add ddl_command_end support for event triggers. Dimitri Fontaine, with slight changes by me --- doc/src/sgml/event-trigger.sgml | 93 ++++++++++++++++++++++++++++++++++++++++- 1 file changed, 91 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/event-trigger.sgml b/doc/src/sgml/event-trigger.sgml index dc4e7614990..f9e27567684 100644 --- a/doc/src/sgml/event-trigger.sgml +++ b/doc/src/sgml/event-trigger.sgml @@ -27,8 +27,9 @@ An event trigger fires whenever the event with which it is associated occurs in the database in which it is defined. Currently, the only - supported event is ddl_command_start. Support for - additional events may be added in future releases. + supported events are ddl_command_start + and ddl_command_end. Support for additional events may be + added in future releases. @@ -43,6 +44,13 @@ CREATE TABLE AS. + + The ddl_command_end event occurs just before returning + control from the execution of a CREATE, ALTER, + or DROP commmand. It shares the same exceptions as + the ddl_command_start event. + + For a complete list of commands supported by the event trigger mechanism, see . @@ -84,328 +92,409 @@ command tag ddl_command_start + ddl_command_end ALTER AGGREGATE X + X ALTER COLLATION X + X ALTER CONVERSION X + X ALTER DOMAIN X + X ALTER EXTENSION X + X ALTER FOREIGN DATA WRAPPER X + X ALTER FOREIGN TABLE X + X ALTER FUNCTION X + X ALTER LANGUAGE X + X ALTER OPERATOR X + X ALTER OPERATOR CLASS X + X ALTER OPERATOR FAMILY X + X ALTER SCHEMA X + X ALTER SEQUENCE X + X ALTER SERVER X + X ALTER TABLE X + X ALTER TEXT SEARCH CONFIGURATION X + X ALTER TEXT SEARCH DICTIONARY X + X ALTER TEXT SEARCH PARSER X + X ALTER TEXT SEARCH TEMPLATE X + X ALTER TRIGGER X + X ALTER TYPE X + X ALTER USER MAPPING X + X ALTER VIEW X + X CREATE AGGREGATE X + X CREATE CAST X + X CREATE COLLATION X + X CREATE CONVERSION X + X CREATE DOMAIN X + X CREATE EXTENSION X + X CREATE FOREIGN DATA WRAPPER X + X CREATE FOREIGN TABLE X + X CREATE FUNCTION X + X CREATE INDEX X + X CREATE LANGUAGE X + X CREATE OPERATOR X + X CREATE OPERATOR CLASS X + X CREATE OPERATOR FAMILY X + X CREATE RULE X + X CREATE SCHEMA X + X CREATE SEQUENCE X + X CREATE SERVER X + X CREATE TABLE X + X CREATE TABLE AS X + X CREATE TEXT SEARCH CONFIGURATION X + X CREATE TEXT SEARCH DICTIONARY X + X CREATE TEXT SEARCH PARSER X + X CREATE TEXT SEARCH TEMPLATE X + X CREATE TRIGGER X + X CREATE TYPE X + X CREATE USER MAPPING X + X CREATE VIEW X + X DROP AGGREGATE X + X DROP CAST X + X DROP COLLATION X + X DROP CONVERSION X + X DROP DOMAIN X + X DROP EXTENSION X + X DROP FOREIGN DATA WRAPPER X + X DROP FOREIGN TABLE X + X DROP FUNCTION X + X DROP INDEX X + X DROP LANGUAGE X + X DROP OPERATOR X + X DROP OPERATOR CLASS X + X DROP OPERATOR FAMILY X + X DROP RULE X + X DROP SCHEMA X + X DROP SEQUENCE X + X DROP SERVER X + X DROP TABLE X + X DROP TEXT SEARCH CONFIGURATION X + X DROP TEXT SEARCH DICTIONARY X + X DROP TEXT SEARCH PARSER X + X DROP TEXT SEARCH TEMPLATE X + X DROP TRIGGER X + X DROP TYPE X + X DROP USER MAPPING X + X DROP VIEW X + X SELECT INTO X + X -- cgit v1.2.3