The term "trigger function" is a simply a way of
referring to a function that is intended to be invoked by
a trigger. Triggers define operations that are performed when
a specific event occurs within the database. A PostgreSQL
trigger function can be referenced by a trigger as the operation
to be performed when the trigger's event occurs
Create a Trigger Function
To create a trigger function :
- Select the Database in the Tree View and select Others
>
Trigger Function from the toolbar
- Press the
New Trigger Function button
- Enter Trigger Function properties and fields on the appropriate
tabs of the New Trigger Function Editor
- Click OK
Design a Trigger Function
To design a trigger function:
- Select the Database in the Tree View and select Others
>
Trigger Function from the toolbar
- Select the trigger function you want to design.
- Press the
Design Trigger Function button.
- Edit Trigger Function properties and fields on the appropriate
tabs of the Design Trigger Function Editor
- Click OK
Delete a Trigger Function
To delete a trigger function:
- Select the Database in the Tree View and select Others
>
Trigger Function from the toolbar
- Select the trigger function you want to delete.
- Click the
Delete Trigger Function button.
- Confirm deleting in the dialog window.
|