PostgreSQL aborts the transactions on error
You may be surprised by this in PostgreSQL:
⛶postgres=!# commit;
ROLLBACK
postgres=#Yes, I issued a COMMIT but got a ROLLBACK!
I'll demo how it happened and how to avoid it. In short, the transactio...