Suggest A Question : : Frequently Asked Questions : : Search : : Relevant Manuals : :
PHP Questions : : Linux Questions : : MySQL Questions : :

home [ Login ]

Log In
Email
Pass

Forgot Password?
New User, Register here.

Weber Sites

PHP Code Search

Web Development Resources

PHP & MySQL Code Examples

PHP Web Logs (BLogs)

PHP & MySQL Forums

Web Development Index

Web Site Templates

Web Development Manuals

Web Site Uptime Monitor

web development content

Relevant Manuals

Metaprogramming language

Webmaster Resources

Webmaster Forum

Suggest your site

Forex Trading Online forex trading platform

Search Engine Optimization - search engine optimization (SEO) and advertising specialist.

PostgreSQL 7.4.2 Documentation
Prev	Fast Backward	Chapter 43. System Catalogs	Fast Forward	Next

43.28. `pg_trigger`

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.

Prev	Home	Next
`pg_statistic`	Up	`pg_type`

Who's Online
Guest Users: 7

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General