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.