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.
This exercise is part of the course
Transactions and Error Handling in PostgreSQL
Exercise instructions
- Create a transaction.
- Update
FIELD48toMMDAifRCON6810(MMDA value) is greater than5000000. - Set a savepoint named
mmda_flag_set. - Rollback the whole transaction.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
BEGIN;
-- Set the flag to indicate that they hold MMDAs where more than $5 million
UPDATE ffiec_reci
SET FIELD48 = '___'
WHERE ___ > 5000000;
-- Set a savepoint
___ ___;
-- Rollback the whole transaction
___;
COMMIT;