Putting it all together
Now you're ready to put together what you learned in Chapter 4 with the stacked diagnostics functions from the previous exercises. I've already created the patients
table from the prior exercise as well as the debug_statement
function. You'll begin by debugging another exception type. Then you'll combine a DO
function, SQL statements stored in a variable, and trigger debugging on an exception.
This exercise is part of the course
Transactions and Error Handling in PostgreSQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
