3.28. pg_trigger

This system catalog stores triggers on tables. See under CREATE TRIGGER for more information.

Table 3-28. pg_trigger Columns

tgrelidoidpg_class.oidThe table this trigger is on
tgnamename Trigger name (must be unique among triggers of same table)
tgfoidoidpg_proc.oidThe function to be called
tgtypeint2 Bitmask identifying trigger conditions
tgenabledbool True if trigger is enabled (not presently checked everywhere it should be, so disabling a trigger by setting this false does not work reliably)
tgisconstraintbool True if trigger implements an RI constraint
tgconstrnamename RI constraint name
tgconstrrelidoidpg_class.oidThe table referenced by an RI constraint
tgdeferrablebool True if deferrable
tginitdeferredbool True if initially deferred
tgnargsint2 Number of argument strings passed to trigger function
tgattrint2vector Currently unused
tgargsbytea Argument strings to pass to trigger, each null-terminated

Note: pg_class.reltriggers needs to match up with the entries in this table.

© Copyright 2003-2023 The ultimate PHP Editor and PHP IDE site.