Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Auto-Rollback option - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: [GENERAL] Auto-Rollback option
Date
Msg-id 20170213144915.s2te7lsrtplpfuo5@hermes.hilbert.loc
Whole thread Raw
In response to [GENERAL] Auto-Rollback option  (Małgorzata Hubert <gosiahubert@gmail.com>)
List pgsql-general
Tree view 
On Mon, Feb 13, 2017 at 02:55:03PM +0100, Małgorzata Hubert wrote:

> 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.

Auto-Rollback is the implicit default.

Regards,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Auto-Rollback option