Take a look at ON_ERROR_STOP variable.
\set ON_ERROR_STOP 1
On 13/02/2017 15:55, Małgorzata Hubert wrote:
> Hi,
> is there any way to set Auto-Rollback : ON, automaticly during instalation process or using query (maybe something like set autocommit = 'on')?
> We need it to automaticly close the transaction if an error occures during implementing patches.
>
> Thanks in advanced for the answear.
> Best regards,
> Malgorzata Pomykacz
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt