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; 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). When I turn the Auto-Rollback on everything is ok : in situation like this my transaction is automatically rollbacked and closed. 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). I'm using 1.22.1 version. -- View this message in context: http://postgresql.nabble.com/Auto-Rollback-option-tp5943942p5943950.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
