RECREATE EXCEPTION
Drops a custom exception if it exists, and creates a custom exception
Available in
DSQL
Syntax
RECREATE EXCEPTION exception_name '<message>'
!! See syntax of CREATE EXCEPTION
for further rules !!
The statement RECREATE EXCEPTION
creates a new exception for use in PSQL modules.If an exception with the same name exists already, the RECREATE EXCEPTION
statement will try to drop it and create a new one.If there are any dependencies on the existing exception, the attempted deletion fails and RECREATE EXCEPTION
is not executed.