pg_trigger v7.4
This section is adapted from the WarehousePG v7.x documentation
The pg_trigger system catalog table stores triggers on tables.
Note WarehousePG does not support triggers.
| column | type | references | description |
|---|---|---|---|
oid | oid | The object ID | |
tgrelid | oid | pg_class.oid Note that WarehousePG does not enforce referential integrity. | The table this trigger is on. |
tgname | name | Trigger name (must be unique among triggers of same table). | |
tgfoid | oid | pg_proc.oid Note that WarehousePG does not enforce referential integrity. | The function to be called. |
tgtype | smallint | Bit mask identifying trigger conditions. | |
tgenabled | char | True if trigger is enabled. | |
tgisinternal | boolean | True if trigger is internally generated (usually, to enforce the constraint identified by tgconstraint). | |
tgconstrrelid | oid | pg_class.oid Note that WarehousePG does not enforce referential integrity. | The table referenced by an referential integrity constraint. |
tgconstrindid | oid | pg_class.oid | The index supporting a unique, primary key, or referential integrity constraint. |
tgconstraint | oid | pg_constraint.oid | The pg_constraint entry associated with the trigger, if any. |
tgdeferrable | boolean | True if deferrable. | |
tginitdeferred | boolean | True if initially deferred. | |
tgnargs | smallint | Number of argument strings passed to trigger function. | |
tgattr | int2vector | Currently not used. | |
tgargs | bytea | Argument strings to pass to trigger, each NULL-terminated. | |
tgqual | pg_node_tree | Expression tree (in nodeToString() representation) for the trigger's WHEN condition, or null if none. | |
tgoldtable | name | The name of the old transition table, or NULL if none. | |
tgnewtable | name | The name of the new transition table, or NULL if none. |
Parent topic: System Catalogs Definitions