pg_trigger#

The pg_trigger system catalog table stores triggers on tables.

Note: OushuDB does not support triggers.

Table 1. pg_catalog.pg_trigger

column

type

references

description

tgrelid

oid

pg_class_internal.oidNote that OushuDB 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.oidNote that OushuDB 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_internal.oidNote that OushuDB 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.