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