Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the Compound Trigger dialog to create a compound trigger or modify an
existing compound trigger. Compound Trigger is supported only for EPAS server
12 and above. A compound trigger executes a specified code when certain events
The Compound Trigger dialog organizes the development of a compound trigger
through the following dialog tabs: General, Events, and Code. The SQL
tab displays the SQL code generated by dialog selections.
Use the fields in the General tab to identify the compound trigger:
Click the Events tab to continue.
Use the fields in the Events tab to specify how and when the compound trigger fires:
Click the Code tab to continue.
Use the Code field to specify the code for the five timing events
BEFORE STATEMENT, AFTER STATEMENT, BEFORE EACH ROW, AFTER EACH ROW,
INSTEAD OF EACH ROW that will be invoked when the compound trigger fires.
Basic template is provided with place holders.
Click the SQL tab to continue.
Your entries in the Compound Trigger dialog generate a SQL command (see an example
below). Use the SQL tab for review; revisit or switch tabs to make any changes
to the SQL command.
The following is an example of the sql command generated by user selections in
the Compound Trigger dialog:
The example demonstrates creating a compound trigger named test_ct.