↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 6.3
Historical version. PostgreSQL 6.3 has reached end of support. See the current manual.
PostgreSQL
PrevNext

Chapter 38. Triggers

Table of Contents
Trigger Creation
Interaction with the Trigger Manager
Visibility of Data Changes
Examples

While the current version of Postgres has various client interfaces such as Perl, Tcl, Python and C, it lacks an actual Procedural Language (PL). We hope to have a proper PL one day. In the meantime it is possible to call C functions as trigger actions. Note that STATEMENT-level trigger events are not supported in the current version. You can currently specify BEFORE or AFTER on INSERT, DELETE or UPDATE of a tuple as a trigger event.


PrevHomeNext
SunOS 4.x, Solaris 2.x and HP-UXUpTrigger Creation

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.