Online Documentation for SQL Manager for PostgreSQL
Editing trigger definition
Use the Trigger tab of Trigger Editor to create/edit a table trigger and specify its properties.
Enter a name for the new trigger, or modify the name of the trigger being edited.
Enables/disables the trigger immediately after it is created.
For table or view
Check this option to create a constraint trigger with adjusted timing of firing. A constraint trigger can only be of After Row type.
Select the table for the trigger.
This option controls whether the trigger can be deferred. Set this option to fire the trigger at the end of the containing transaction, otherwise it's fired at the end of the statement causing the triggering event.
This option specifies the default timing of the trigger: deferred trigger can be fired immediately or can be deferred.
Select the trigger behaviour type:
Specifies that the trigger is fired before the event.
Specifies that the trigger is fired after the event.
This specifies whether the trigger procedure should be fired once for every row affected by the trigger event, or just once per SQL statement.
Specify the data modification statements that activate the trigger when it is tried against this table: Insert, Update, Delete or Truncate (ON TRUNCATE is supported only from PostgreSQL version 8.4). At least one option must be specified.
From this drop-down list you can select the columns that will be updated.
Define statement for WHEN condition of the trigger.
A user-supplied function that is declared as taking no arguments and returning type trigger, which is executed when the trigger fires. You can use already existing function or create new one.
This area allows you to specify an optional list of arguments to be provided to the function when the trigger is executed. The arguments are literal string constants. Simple names and numeric constants may be written here, too, but they will all be converted to strings.
Set the arguments by right-clicking in the list and selecting Add argument from the context menu (or by pressing the corresponding button). After the argument is added, set its value in the Argument Value field. To delete the existing argument, select Delete argument from the context menu (or press the corresponding button).
To change the arguments order, use the Move Up / Move Down context menu items or the buttons.
The Definition area below specifies the trigger conditions and actions that determine whether the tried DML statements cause the trigger actions to be performed. The trigger actions take effect when the DML operation is performed.