Timeline for Does UPDATE FROM VALUES lock rows in the order they are listed?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 4, 2023 at 20:52 | comment | added | Laurenz Albe | Right. If you don't wait for the lock, the row cannot have changed since you took the snapshot. | |
| Feb 4, 2023 at 2:39 | comment | added | ChrisJ | Oh sorry, I misread. It's not related to locking but rather the warning about READ COMMITTED mode where rows may come back in a different order | |
| Feb 4, 2023 at 2:38 | comment | added | ChrisJ |
Thanks. The behaviour you describe for NOWAIT does not seem to be in the documentation? postgresql.org/docs/current/sql-select.html Based on the docs it seems purely for avoiding waiting, it doesn't mention that it will impact ordering and deadlock avoidance
|
|
| Feb 4, 2023 at 2:28 | vote | accept | ChrisJ | ||
| Feb 4, 2023 at 2:29 | |||||
| Jan 31, 2023 at 6:53 | history | answered | Laurenz Albe | CC BY-SA 4.0 |