| PostgreSQL 8.0.12 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.
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
In order to submit a comment, you must have a community account.
* denotes required field