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.
Este ejercicio forma parte del curso
Transactions and Error Handling in PostgreSQL
Instrucciones del ejercicio
- Create a transaction.
- Update
FIELD48toMMDAifRCON6810(MMDA value) is greater than5000000. - Set a savepoint named
mmda_flag_set. - Rollback the whole transaction.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
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;