by default INSERT, UPDATE, DELETE operations is transactions postgre

Question

Hi, do I understand correctly that, by default INSERT, UPDATE, DELETE operations is transactions?

Sachin Singh · Accepted Answer

Yes, these are all transactions. When we perform certain opertations such that if any one fail then all should fail, then we explicitely put all of them in a single transaction so that DB integrity is maintained.   For example while transfering an amount from 1 bank account to another, if amount from one account gets deducted but not added to the other account then database will be in an inconsistant state to avoid this we put such transactions in a single transaction.   -- begin the transaction   BEGIN;      -- deduct the amount from the account 1   UPDATE accounts    SET balance = balance - 1500   WHERE id = 1;      -- add the amount to the account 2 from account 1   UPDATE accounts   SET balance = balance + 1500   WHERE id = 2;       -- roll back the transaction   ROLLBACK;

Deepak · Answer

Thanks bro