Set autocommit to "true/on". That will give you the desired behavior of allowing all those things that succeed to remain committed. David J. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Vogt, Michael Sent: Monday, March 14, 2011 5:24 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Autocommit off - commits/rollbacks Hey all Or can postgres behavior be changed to a "commit whatever is possible" mode? Regards michu -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general