On Mon, Mar 14, 2011 at 03:55:37PM +0100, Vogt, Michael wrote: > Why does postgres rollback the whole transaction after an error? I > compared the behavior with oracle/hsql - those dbms commit whats > possible. A transaction is supposed to commit or rollback. If you want to hold on to something that you've done and then try something (and pursue alternatives depending on whether you get an error), use a savepoint. See http://www.postgresql.org/docs/9.0/interactive/tutorial-transactions.html A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
