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