Chapter 36. Triggers
- Table of Contents
- 36.1.Overview of Trigger Behavior
- 36.2.Visibility of Data Changes
- 36.3.Writing Trigger Functions in C
- 36.4.A Complete Trigger Example
- 36.1.Overview of Trigger Behavior
This chapter provides general information about writing trigger functions. Trigger functions can be written in most of the available procedural languages, includingPL/pgSQL (Chapter 40),PL/Tcl (Chapter 41),PL/Perl (Chapter 42), andPL/Python (Chapter 43). After reading this chapter, you should consult the chapter for your favorite procedural language to find out the language-specific details of writing a trigger in it.
It is also possible to write a trigger function in C, although most people find it easier to use one of the procedural languages. It is not currently possible to write a trigger function in the plain SQL function language.