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

Exercise

Working with repeatable read

With the video in mind, let's do some hands on work with a repeatable read transaction. We want to set a "stability" factor for a bank's in-house assets if they allow consumer deposits. We'll do this by setting a custom field, FIELD48, equal to a retainer value if the bank allows consumer deposit accounts as indicated in RCONP752.

Interference from an external transaction would alter the application of our factor. Repeatable read protects your transaction from outside sources changing data that was available to us when we ran our first query in the transaction.

Instructions 1/2

undefined XP
    1
    2
  • Start a transactions in the repeatable read isolation level.
  • End the transaction.