Understanding Transactions and Rollbacks in PostgreSQL: Best Practices for Data Consistency and Integrity.