Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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