Re: Auto-Rollback option

On Mon, Feb 13, 2017 at 1:10 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 02/13/2017 09:59 AM, John R Pierce wrote:
>
>> On 2/13/2017 7:15 AM, mpomykacz wrote:
>>
>>> So my problem is like this:
>>>
>>> I start the transaction with BEGIN TRANSACTION;
>>> Then I have for example some INSERTs to DB
>>> and at the end COMMIT; and END TRANSACTION;
>>>
>>
>> COMMIT ends the transaction. In PostgreSQL, END TRANSACTION is
>> redundant, equivalent to COMMIT, do one or the other, not both.
>>
>>
>>> But if one of this INSERTs causes error, the transaction will stop
>>> (but it
>>> is still open and next patch is implemented within the same transaction).
>>>
>>
>> Patch ?
>>
>
> Pretty sure the OP is applying a series of SQL driven patches to
> add/change/remove database schema.
>
>
>>
>>> When I turn the Auto-Rollback on everything is ok : in situation like
>>> this
>>> my transaction is automatically rollbacked and closed.
>>>
>>
>> there is no autorollback option in standard PostgreSQL ?
>>
>>
>>> But I do not want to do the Auto-Rollback click manualy in the Option
>>> menu
>>> or query editor window (because I can not be sure that the person who
>>> will
>>> run the patch would remember about this click).
>>>
>>
>> option? query editor window? what software are you talking about?
>>
>
> I would say pgAdmin3:
>
> https://www.pgadmin.org/download/source.php
>
>
>> I'm using 1.22.1 version.
>>>
>>
>> 1.22.1 version? PostgreSQL versions currently supported are 9.2.x to
>>
>
> See above.
>
> 9.6.x
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

1.22.1 version refers to PgAdmin3. It is not the PostgreSQL version.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.