[GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Vogt, Michael
Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? I compared the behavior with oracle/hsql - those dbms commit whats po

[GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Vogt, Michael
Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? I compared the behavior with oracle/hsql - those dbms commit whats po

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-15 Thread Vogt, Michael
? Regards and thanks in advance michael -Ursprüngliche Nachricht- Von: Alexander Pyhalov [mailto:a...@rsu.ru] Gesendet: Montag, 14. März 2011 17:28 An: Vogt, Michael Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] Autocommit off - commits/rollbacks Hello. On 03/14/2011 12:24, Vogt