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 ?
>
> 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'm using 1.22.1 version.
1.22.1 version? PostgreSQL versions currently supported are 9.2.x to
9.6.x
--
john r pierce, recycling bits in santa cruz