Lectures

In this lecture, you'll learn how to automate logging changes and auditing data in PostgreSQL using triggers. We'll go over creating a log table, writing functions and triggers to track INSERT, UPDATE, DELETE operations, plus check out some real-world examples and important performance tips.

In this lecture, you'll learn how to use a trigger and a PL/pgSQL function to automatically update the last_modified field in a table whenever the data changes. We'll go over creating the table, the function, a trigger with a condition, and also look at common mistakes and tips for using triggers in PostgreSQL.

In this lecture, you'll learn the difference between FOR EACH ROW and FOR EACH STATEMENT triggers in PostgreSQL, figure out how to pick the right type for your tasks, check out some practical examples, and go over common mistakes when designing triggers.

In this lecture, you'll learn how to handle errors and manage transactions inside PostgreSQL triggers using EXCEPTION blocks and the RAISE statement. We'll check out practical examples of logging errors, diagnosing with RAISE, and also look at common mistakes and ways to avoid them when working with triggers.

In this lecture, you'll learn about the most common mistakes when creating triggers in PostgreSQL: recursion, incorrect use of OLD/NEW, conflicting triggers, performance and transaction issues. We'll break down examples, ways to avoid mistakes, and give you some practical tips for writing reliable and efficient triggers.