Schedule - PGConf.EU 2022
Trigger: How it Works in PostgreSQL Internals
Date: 2022-10-26
Time: 11:10–12:00
Room: Berlin 1
Level: Intermediate
Trigger is a basic feature of database systems and can be used for audit logging, automatically populating other tables, checking or enforcing complex constraints, and so on. For example, the foreign key constraint in PostgreSQL relies on the triggers internally.
This talk will explain how triggers work in PostgreSQL internals. I will cover how triggers are managed, how trigger functions are fired, how triggers are used internally, and the relationship to constraints. This will help you understand PostgreSQL's triggers in more detail.
Slides
The following slides have been made available for this session: