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