Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Trigger Function
 

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 :

  1. Select the Database in the Tree View and select Others > Trigger Function from the toolbar
  2. Press the New Trigger Function button
  3. Enter Trigger Function properties and fields on the appropriate tabs of the New Trigger Function Editor
  4. Click OK

Design a Trigger Function

To design a trigger function:

  1. Select the Database in the Tree View and select Others > Trigger Function from the toolbar
  2. Select the trigger function you want to design.
  3. Press the Design Trigger Function button.
  4. Edit Trigger Function properties and fields on the appropriate tabs of the Design Trigger Function Editor
  5. Click OK

Delete a Trigger Function

To delete a trigger function:

  1. Select the Database in the Tree View and select Others > Trigger Function from the toolbar
  2. Select the trigger function you want to delete.
  3. Click the Delete Trigger Function button.
  4. Confirm deleting in the dialog window.