ON_ERROR_STOP
By default, if a script command results in an error, for example, because of a malformed command or invalid data format, processing continues. If you set ON_ERROR_STOP
to ‘on’
in a script and an error occurs during processing, the script terminates immediately.
If you set ON_ERROR_STOP
to ‘on’
in a script, run the script from Linux using vsql -f <
filename>
, and an error occurs, vsql returns an error code 3 to Linux to indicate that the error occurred in a script.
To enable ON_ERROR_STOP
:
=> \set ON_ERROR_STOP on
To disable ON_ERROR_STOP
:
=> \set ON_ERROR_STOP off