© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
B. Shaik, D. K. ChemuduruProcedural Programming with PostgreSQL PL/pgSQLhttps://doi.org/10.1007/978-1-4842-9840-4_16

16. Transaction Management

Baji Shaik1   and Dinesh Kumar Chemuduru2
(1)
Texas, TX, USA
(2)
Andhra Pradesh, India
 

In the previous chapter, we talked about triggers in PostgreSQL and how to build trigger functions in PL/pgSQLPL/pgSQLreturn values/parameters. We covered different types of triggers with examples and use cases when to use each type of trigger. We explained advantages and disadvantages of triggers. In this chapter, we will cover transaction management in PL/pgSQL and how to write proper transactional code. By the end of this chapter, ...

Get Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.