Subject Another questions about transactions
Author W O
Hello everybody

- Transaction 510 inserts a new row
- Transaction 510 commit
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535 start
- Transaction 535 wants to update the row inserted by transaction 510 but
unsuccesfully because transaction 526 has locked it
- Transaction 526 commit

Can now transaction 535 update the row inserted by transaction 510? In this
case, updates makes for transaction 526 will be lost, right?

Or transaction 535 should first to read the new row commited (the 526)
before making the update?

Greetings.

Walter.


[Non-text portions of this message have been removed]