Bruce Momjian <[EMAIL PROTECTED]> writes: > We are considering allowing COMMIT IGNORE ABORT for scripts that want to > do a subtransaction, but don't care if it fails, and because it is a > script, they can't test the return value to send ROLLBACK:
While we clearly want this functionality, I tend to agree with Barry that COMMIT IGNORE ABORT (and the other variants that have been floated) is a horrid, confusing name for it. I would suggest using END with some modifier, instead. Perhaps END [ WORK | TRANSACTION ] [ IGNORE ERRORS ] END doesn't so directly imply that you are trying to commit a failed transaction. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings