Ok, thanks for the answers. But unfortunatelly they did not solve my problem.
I will move it to the pgadmin subforum.
Thanks:)
--
View this message in context:
http://postgresql.nabble.com/Auto-Rollback-option-tp5943942p5944159.html
Sent from the PostgreSQL - general mailing list archive at Nab
Yes, I'm talking about pgAdmin III - sorry...
I think that auto-commit is on on default but auto-rollback is off. But I'll
check if you say so.
And I know I can check the box next to Enable Auto ROLLBACK but I'm trying
to avoid it and enable auto rollback not by a manual way.
--
View this mess
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
