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...