| PostgreSQL 7.4 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 43. System Catalogs | Fast Forward | Next |
The catalog pg_trigger stores triggers on tables. See under CREATE TRIGGER for more information.
Table 43-28. pg_trigger Columns
| Name | Type | References | Description |
|---|---|---|---|
| tgrelid | oid | pg_class.oid | The table this trigger is on |
| tgname | name | Trigger name (must be unique among triggers of same table) | |
| tgfoid | oid | pg_proc.oid | The function to be called |
| tgtype | int2 | Bit mask identifying trigger conditions | |
| tgenabled | bool | True if trigger is enabled (not presently checked everywhere it should be, so disabling a trigger by setting this false does not work reliably) | |
| tgisconstraint | bool | True if trigger implements a referential integrity constraint | |
| tgconstrname | name | Referential integrity constraint name | |
| tgconstrrelid | oid | pg_class.oid | The table referenced by an referential integrity constraint |
| tgdeferrable | bool | True if deferrable | |
| tginitdeferred | bool | True if initially deferred | |
| tgnargs | int2 | Number of argument strings passed to trigger function | |
| tgattr | int2vector | Currently unused | |
| tgargs | bytea | Argument strings to pass to trigger, each null-terminated |
Note: pg_class.reltriggers needs to match up with the entries in this table.