Date: 2022-05-27
Time: 11:15–12:15
Room: Stream 2
Level: Intermediate
Triggers are a basic feature of database systems and it can be used for audit logging, automatically populating other tables, checking or enforcing complex constraints, and so on. Actually, the foreign key constraint in PostgreSQL is relying 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 it is used internally, and the relationship to constrains. This will be helpful in understanding PostgreSQL's triggers in more details.