Re: Auto-Rollback option

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Mon, 13 Feb 2017 16:52:36 +0200



    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