Lectures

In this lecture, you'll learn how to pull off "nested transactions" in PostgreSQL using savepoints (SAVEPOINT), how to partially roll back changes inside a single transaction, and you'll get some hands-on tips for using SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT to flexibly handle errors and stages in tricky database scenarios.

In this lecture, you'll learn how functions and procedures work in PostgreSQL 17 in the context of transactions: what makes them different, how to manage transactions inside procedures, how to do partial rollbacks, and what limitations exist with nested calls. There are practical examples and answers to common questions.

In this lecture, you'll learn how to build multi-step procedures in PostgreSQL: validate data, perform inserts, and log actions all within a single transaction. We'll break down the difference between functions and procedures, how to handle errors, use savepoints, and best practices for multi-step business logic.

In this lecture, you'll learn how to use EXCEPTION and RAISE blocks in PostgreSQL to handle errors, partially roll back changes, and log errors in PL/pgSQL functions and procedures. We'll break down the syntax, limitations, real-life examples, and best practices for making your business operations more robust.

In this lecture, you'll learn how to use dynamic SQL in PL/pgSQL with the EXECUTE command: how to create and modify tables with dynamic names, build universal procedures, and protect yourself from SQL injection. Real-life examples and security tips will help you automate complex tasks in PostgreSQL.