pg_trigger
The pg_trigger
system catalog table stores triggers on tables.
Note: HAWQ does not support triggers.
Table 1. pg_catalog.pg_trigger
column | type | references | description |
---|---|---|---|
tgrelid |
oid | pg_class.oid
Note that HAWQ 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 HAWQ does not enforce referential integrity. |
The function to be called. |
tgtype |
smallint | Bit mask identifying trigger conditions. | |
tgenabled |
boolean | True if trigger is enabled. | |
tgisconstraint |
boolean | True if trigger implements a referential integrity constraint. | |
tgconstrname |
name | Referential integrity constraint name. | |
tgconstrrelid |
oid | pg_class.oid
Note that HAWQ does not enforce referential integrity. |
The table referenced by an referential integrity constraint. |
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. |