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

Exercise

Working with a single savepoint

Banks that carry large value in Money Market Deposit Accounts (MMDA) are often resilient to downturns in the economy. In order to classify banks, we'll use a flag field such as FIELD48 to store information useful for further processing. Let's flag banks with over 5000000.

Instructions

100 XP
  • Create a transaction.
  • Update FIELD48 to MMDA if RCON6810 (MMDA value) is greater than 5000000.
  • Set a savepoint named mmda_flag_set.
  • Rollback the whole transaction.