Lectures

In this lecture, you'll learn how to generate and handle errors in PL/pgSQL using the RAISE statement. We'll check out message levels, syntax, usage examples, error handling in functions, and common mistakes when working with RAISE EXCEPTION. This will help make your procedures reliable and easy to debug.

In this lecture, you'll learn how to use the RAISE NOTICE statement for logging and debugging functions in PL/pgSQL. We'll check out examples of printing variables, tracking execution steps, and share some tips for using logs effectively in PostgreSQL.

Learn how to create an error_log table for storing errors in PostgreSQL, implement an error logging function, and automate error recording using exception handling. This will help you analyze failures, improve your code quality, and quickly react to issues in your database.

In this lecture, you'll learn how to set up automatic logging of errors and warnings in PostgreSQL using custom functions. We'll go over creating a log table, a universal function for recording errors, and some practical examples of using logging in real-world tasks and exception handling.

In this lecture, we're gonna check out the most common mistakes when using control structures and logging in PL/pgSQL: from syntax slip-ups and forgotten blocks to bad error handling and logging fails. You'll learn how to spot and avoid these mistakes, so you can write reliable and clean code.