pg_trigger
The pg_trigger
system catalog table stores triggers on tables.
Note LightDB-A Database does not support triggers.
column | type | references | description |
---|---|---|---|
tgrelid |
oid | pg_class.oid Note that LightDB-A Database 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 LightDB-A Database does not enforce referential integrity. |
The function to be called. |
tgtype |
int2 | Bit mask identifying trigger conditions. | |
tgenabled |
boolean | 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 LightDB-A Database 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 |
int2 | 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. |
Parent topic: System Catalogs Definitions