Skip to content

pg_trigger

The pg_trigger system catalog table stores triggers on tables.

Note WarehousePG does not support triggers.

columntypereferencesdescription
tgrelidoidpg_class.oid

Note that WarehousePG does not enforce referential integrity.
The table this trigger is on.
tgnamenameTrigger name (must be unique among triggers of same table).
tgfoidoidpg_proc.oid

Note that WarehousePG does not enforce referential integrity.
The function to be called.
tgtypeint2Bit mask identifying trigger conditions.
tgenabledbooleanTrue if trigger is enabled.
tgisinternalbooleanTrue if trigger is internally generated (usually, to enforce the constraint identified by tgconstraint).
tgconstrrelidoidpg_class.oid

Note that WarehousePG does not enforce referential integrity.
The table referenced by an referential integrity constraint.
tgconstrindidoidpg_class.oidThe index supporting a unique, primary key, or referential integrity constraint.
tgconstraintoidpg_constraint.oidThe pg_constraint entry associated with the trigger, if any.
tgdeferrablebooleanTrue if deferrable.
tginitdeferredbooleanTrue if initially deferred.
tgnargsint2Number of argument strings passed to trigger function.
tgattrint2vectorCurrently not used.
tgargsbyteaArgument strings to pass to trigger, each NULL-terminated.
tgqualpg_node_treeExpression tree (in nodeToString() representation) for the trigger's WHEN condition, or null if none.

Parent topic: System Catalogs Definitions