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. |