03-15-2021, 04:40 PM
Summary: in this tutorial, you will learn how to catch PostgreSQL exceptions in PL/pgSQL.
Introduction to the PL/pgSQL Exception clause
When an error occurs in a block, PostgreSQL will abort the execution of the block and also the surrounding transaction.
To recover from the error, you can use the exception clause in the begin...end block.
The following illustrates the syntax of the exception clause:
Read More : https://reconshell.com/postgresql-exception/
Introduction to the PL/pgSQL Exception clause
When an error occurs in a block, PostgreSQL will abort the execution of the block and also the surrounding transaction.
To recover from the error, you can use the exception clause in the begin...end block.
The following illustrates the syntax of the exception clause:
Read More : https://reconshell.com/postgresql-exception/