| PostgreSQL 8.0.17 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 41. System Catalogs | Fast Forward | Next |
The catalog pg_trigger stores triggers on tables. See CREATE TRIGGER for more information.
Table 41-29. 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 agree with the number of triggers found in this table for the given relation.
No comments could be found for this page.
New comments cannot be added to old documentation versions.