Subject | A question about WAIT |
---|---|
Author | W O |
Post date | 2013-01-07T21:32:53Z |
- Transaction 510 inserts a new row
- Transaction 510 commits
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535 start, with the clause WAIT
- Transaction 535 wants to update the row inserted by transaction 510 but
unsuccessfully because it is locked by transaction 526
- Transaction 526 commits
- Transaction 535 can now update the row inserted by transaction 510? or
neither with the clause WAIT can do that?
Greetings.
Walter.
[Non-text portions of this message have been removed]
- Transaction 510 commits
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535 start, with the clause WAIT
- Transaction 535 wants to update the row inserted by transaction 510 but
unsuccessfully because it is locked by transaction 526
- Transaction 526 commits
- Transaction 535 can now update the row inserted by transaction 510? or
neither with the clause WAIT can do that?
Greetings.
Walter.
[Non-text portions of this message have been removed]