On Sep 18, 2013, at 7:23 AM, David Johnston <polobo@xxxxxxxxx> wrote: > If an exception gets that far your transaction > has failed and you have to ROLLBACK. Right, and after my prior post where I suggested rollback, I realized, it may be the case OP doesn't even realize there's an open transaction, which must eventually be committed or rolled back... -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin