Re: [GENERAL] How to stop implicit rollback on certain errors?

At 01:18 AM 09-12-1999 +0100, Peter Eisentraut wrote:
>Seriously, why do you use a transaction, when you don't want any errors
>caught? Transactions are defined as everything succeeds or nothing goes.
>If you want update to succeed anyhow, put it in it's own transaction
>(i.e., commit before it).

I want errors caught, most errors abort everything but some errors I want
to try a different update instead, if that doesn't work then only rollback
everything.

>> I guess that's expected, and I should insert big years using another less
>> ambiguous format. What is the recommended format?
>
>The safest way would be to set a date format with SET DATESTYLE TO and use
>that, possibly assisted by library formatting routines.

OK.

Link.