1. Learn
    2. /
  2. Courses
    3. /
  3. Transactions and Error Handling in PostgreSQL

Exercise

Using rollbacks

Recently the FFIEC changed the reporting requirement for bank's that provide consumer deposit accounts if they have more than $5,000,000 in brokered deposits. Let's use a transaction to make that update safely. The "Provides Consumer Deposits" flag is in the RCONP752 column and the amount of brokered deposits is in the RCON2365 column.

Instructions 1/2

undefined XP
    1
    2
  • BEGIN the transaction.
  • Update the RCONP752 field to be true if RCON2365 > 5000000.
  • Undo the mistake.