Replies: 1 comment 1 reply
-
Can you please create a reproduction of the same and the share the repo? |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I'm running some tests with isolation in Postgres
I create a transaction with the isolation type repeatable read
After that, I perform a query using the newly created transaction.
Through a second transaction, before committing the firstTransaction, I read, update and commit the data read by the firstTransaction
After changes using the second transaction I update the same data again using the firstTransaction
What is expected is that the firstTransaction commit gives an error and that is not what is happening, the commit passes normally
I simulated this through two Postgres terminals and it worked as expected, the firstTransaction after reading and changing the data does not accept the commit if this data is changed by another transaction before its commit
Note: I am correctly using firstTransaction when reading and changing data
A simple project that simulates the problem:
https://github.com/mkevison/repeatable-read
Beta Was this translation helpful? Give feedback.
All reactions