Chris Angelico, 10.12.2012 16:47:
The other part of the problem is that you're using transactions for something other than transactional integrity. You're batching up transactions in order to improve performance. That's certainly possible, but you're using the database "oddly", so you can't expect it to behave according to your modified set of rules. That's why the transaction functions like a transaction, not like a commit-point.
Just as a side-note: Oracle also allows you to commit a "transaction" even if some of the statements failed e.g. the commit of 20 inserts would only "commit" the ones that were successful. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
