Lectures

In this lecture, you'll learn how to effectively debug functions and procedures in PL/pgSQL: use RAISE NOTICE for logging, analyze input data, use third-party tools (like pgAdmin), and also optimize and improve your code. Practical examples and tips will help you find and fix bugs in PostgreSQL way faster.

In this lecture, you'll learn how functions and procedures in PostgreSQL can call each other, pass parameters, return values, and work together to implement complex business logic. Examples, common mistakes, and why this matters for real-world projects.

In this lecture, you'll learn how to use logging levels in PostgreSQL and PL/pgSQL: NOTICE, WARNING, and EXCEPTION. You'll figure out how to properly format messages, log function execution steps, handle errors, and avoid common pitfalls when debugging and maintaining your code.

In this lecture, you'll learn how to use the PERFORM command in PostgreSQL to call functions and run SQL queries inside PL/pgSQL without handling any returned data. We'll break down practical examples, common mistakes, and tips for using PERFORM effectively for logging, updating data, and running helper operations.

In this lecture, you'll learn how to use PostgreSQL's built-in functions current_query() and pg_current_xact_id() to analyze running SQL queries and transactions, log operations, track down issues, and audit your database's activity. Real-world examples and tips will help you get a deeper understanding of PostgreSQL's inner workings.