Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System Manage triggers

Trigger is a specification that the database should automatically execute a particular function whenever a certain type of operation is performed. Triggers can be defined to execute either before or after any INSERT, UPDATE, or DELETE operation.

The trigger function (Chapter not found) must be defined before the trigger itself can be created. The same trigger function can be used for multiple triggers.

PostgreSQL supports two types of triggers:

  • per-row trigger -  a trigger function that is invoked once for each row that is affected by the statement that 'fired' the trigger.
  • per-statement trigger occurs only once per INSERT, UPDATE, or DELETE statement.

Editing table triggers is done in the tab Triggers

  • New - opens a dialog to enter a new trigger.
  • Edit - opens trigger editing dialog. Also, this dialog can be opened by double clicking a trigger name in the list.
  • Drop — deletes a trigger

Creating/editing a trigger:

Edit Trigger

  • Name - The trigger name must be unique in the database.
  • Timing - The trigger can be specified to 'fire' either BEFORE the operation is attempted on a row or AFTER the operation has completed.
  • Event - Operation that 'fires' the trigger: INSERT, UPDATE or DELETE
  • Orientation - Type of trigger: per-row trigger (ROW) and per-statement trigger (STATEMENT).
  • Procedure - Trigger function invoked when trigger 'fires'.
  • Parameters - The list of parameters influencing the trigger function.