This site is about a previous instance of this event. For the current event, please see the updated site.

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.


The following slides have been made available for this session:


Yugo Nagata