Conference 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.


Yugo Nagata