CREATE OR REPLACE FUNCTION public.cmd_trg_info(tg_when text, cmd_tag text, objectid oid, schemaname text, objectname text)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE E'Command trigger: tg_when=\'%\' cmd_tag=\'%\' objectid=% schemaname=\'%\' objectname=\'%\'', tg_when, cmd_tag, objectid, schemaname, objectname;
END; $function$;


CREATE OR REPLACE FUNCTION public.cmd_trg_info_any(tg_when text, cmd_tag text, objectid oid, schemaname text, objectname text)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
RAISE NOTICE E'Command trigger on any: tg_when=\'%\' cmd_tag=\'%\' objectid=% schemaname=\'%\' objectname=\'%\'', tg_when, cmd_tag, objectid, schemaname, objectname;
END; $function$;





-- before command triggers

CREATE COMMAND TRIGGER cmd_trg_before_any_command BEFORE ANY COMMAND EXECUTE PROCEDURE cmd_trg_info_any();
CREATE COMMAND TRIGGER cmd_trg_before_alter_aggregate BEFORE ALTER AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_collation BEFORE ALTER COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_domain BEFORE ALTER DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_extension BEFORE ALTER EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_foreign_data_wrapper BEFORE ALTER FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_foreign_table BEFORE ALTER FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_function BEFORE ALTER FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_language BEFORE ALTER LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_operator BEFORE ALTER OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_operator_class BEFORE ALTER OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_operator_family BEFORE ALTER OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_schema BEFORE ALTER SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_server BEFORE ALTER SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_table BEFORE ALTER TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_text_search_configuration BEFORE ALTER TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_text_search_dictionary BEFORE ALTER TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_text_search_parser BEFORE ALTER TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_text_search_template BEFORE ALTER TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_trigger BEFORE ALTER TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_type BEFORE ALTER TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_alter_user_mapping BEFORE ALTER USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_aggregate BEFORE CREATE AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_cast BEFORE CREATE CAST EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_collation BEFORE CREATE COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_conversion BEFORE CREATE CONVERSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_domain BEFORE CREATE DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_extension BEFORE CREATE EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_foreign_data_wrapper BEFORE CREATE FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_foreign_table BEFORE CREATE FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_function BEFORE CREATE FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_index BEFORE CREATE INDEX EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_language BEFORE CREATE LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_operator BEFORE CREATE OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_operator_class BEFORE CREATE OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_operator_family BEFORE CREATE OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_rule BEFORE CREATE RULE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_schema BEFORE CREATE SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_sequence BEFORE CREATE SEQUENCE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_server BEFORE CREATE SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_table BEFORE CREATE TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_text_search_configuration BEFORE CREATE TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_text_search_dictionary BEFORE CREATE TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_text_search_parser BEFORE CREATE TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_text_search_template BEFORE CREATE TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_trigger BEFORE CREATE TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_type BEFORE CREATE TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_user_mapping BEFORE CREATE USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_create_view BEFORE CREATE VIEW EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_aggregate BEFORE DROP AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_cast BEFORE DROP CAST EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_collation BEFORE DROP COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_conversion BEFORE DROP CONVERSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_domain BEFORE DROP DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_extension BEFORE DROP EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_foreign_data_wrapper BEFORE DROP FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_foreign_table BEFORE DROP FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_function BEFORE DROP FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_index BEFORE DROP INDEX EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_language BEFORE DROP LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_operator BEFORE DROP OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_operator_class BEFORE DROP OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_operator_family BEFORE DROP OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_rule BEFORE DROP RULE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_schema BEFORE DROP SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_sequence BEFORE DROP SEQUENCE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_server BEFORE DROP SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_table BEFORE DROP TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_text_search_configuration BEFORE DROP TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_text_search_dictionary BEFORE DROP TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_text_search_parser BEFORE DROP TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_text_search_template BEFORE DROP TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_trigger BEFORE DROP TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_type BEFORE DROP TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_user_mapping BEFORE DROP USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_before_drop_view BEFORE DROP VIEW EXECUTE PROCEDURE cmd_trg_info();




-- after command triggers

CREATE COMMAND TRIGGER cmd_trg_after_any_command AFTER ANY COMMAND EXECUTE PROCEDURE cmd_trg_info_any();
CREATE COMMAND TRIGGER cmd_trg_after_alter_aggregate AFTER ALTER AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_collation AFTER ALTER COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_domain AFTER ALTER DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_extension AFTER ALTER EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_foreign_data_wrapper AFTER ALTER FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_foreign_table AFTER ALTER FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_function AFTER ALTER FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_language AFTER ALTER LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_operator AFTER ALTER OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_operator_class AFTER ALTER OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_operator_family AFTER ALTER OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_schema AFTER ALTER SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_server AFTER ALTER SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_table AFTER ALTER TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_text_search_configuration AFTER ALTER TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_text_search_dictionary AFTER ALTER TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_text_search_parser AFTER ALTER TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_text_search_template AFTER ALTER TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_trigger AFTER ALTER TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_type AFTER ALTER TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_alter_user_mapping AFTER ALTER USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_aggregate AFTER CREATE AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_cast AFTER CREATE CAST EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_collation AFTER CREATE COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_conversion AFTER CREATE CONVERSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_domain AFTER CREATE DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_extension AFTER CREATE EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_foreign_data_wrapper AFTER CREATE FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_foreign_table AFTER CREATE FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_function AFTER CREATE FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_index AFTER CREATE INDEX EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_language AFTER CREATE LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_operator AFTER CREATE OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_operator_class AFTER CREATE OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_operator_family AFTER CREATE OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_rule AFTER CREATE RULE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_schema AFTER CREATE SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_sequence AFTER CREATE SEQUENCE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_server AFTER CREATE SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_table AFTER CREATE TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_text_search_configuration AFTER CREATE TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_text_search_dictionary AFTER CREATE TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_text_search_parser AFTER CREATE TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_text_search_template AFTER CREATE TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_trigger AFTER CREATE TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_type AFTER CREATE TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_user_mapping AFTER CREATE USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_create_view AFTER CREATE VIEW EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_aggregate AFTER DROP AGGREGATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_cast AFTER DROP CAST EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_collation AFTER DROP COLLATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_conversion AFTER DROP CONVERSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_domain AFTER DROP DOMAIN EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_extension AFTER DROP EXTENSION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_foreign_data_wrapper AFTER DROP FOREIGN DATA WRAPPER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_foreign_table AFTER DROP FOREIGN TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_function AFTER DROP FUNCTION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_index AFTER DROP INDEX EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_language AFTER DROP LANGUAGE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_operator AFTER DROP OPERATOR EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_operator_class AFTER DROP OPERATOR CLASS EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_operator_family AFTER DROP OPERATOR FAMILY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_rule AFTER DROP RULE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_schema AFTER DROP SCHEMA EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_sequence AFTER DROP SEQUENCE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_server AFTER DROP SERVER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_table AFTER DROP TABLE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_text_search_configuration AFTER DROP TEXT SEARCH CONFIGURATION EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_text_search_dictionary AFTER DROP TEXT SEARCH DICTIONARY EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_text_search_parser AFTER DROP TEXT SEARCH PARSER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_text_search_template AFTER DROP TEXT SEARCH TEMPLATE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_trigger AFTER DROP TRIGGER EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_type AFTER DROP TYPE EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_user_mapping AFTER DROP USER MAPPING EXECUTE PROCEDURE cmd_trg_info();
CREATE COMMAND TRIGGER cmd_trg_after_drop_view AFTER DROP VIEW EXECUTE PROCEDURE cmd_trg_info();