The discussion on triggers, their usage and helpfulness in a database, similarly to functions, tend to polarize experts. Some find them evil, others, the solution for almost all problems. On a closer look, arguments in favor or against them basically converge on topics that are more fundamental than triggers themselves, such as bad programming practices or missing knowledge on the way they are executed and how they relate to SQL. In this talk you will get an introduction on the creation and management of triggers in PostgreSQL and an overview of best practices, potential pitfalls as well as some insights on using them in combination with other features. Some knowledge of plpgsql is an advantage but not a killer criterium for attending the talk.
The following slides have been made available for this session: