Yeah this is correct. I didn't realize it. Most RDBMSs don't behave this way. They allow you to correct exceptions that occur for anything less than a deadlock

Yeah this is correct. I didn't realize it. Most RDBMSs don't behave this way. They allow you to correct exceptions that occur for anything less than a deadlock without a total rollback, but not Postgres.