Timeline for If the maximum current value of an ID generated by a sequence is N, does that guarantee that all future rows will have index > N?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 26, 2021 at 21:18 | comment | added | Simon Notley | Thanks, that's what I thought. And by extension this cannot possibly be a reliable way of deleting the right rows, agreed? | |
| Jan 26, 2021 at 20:50 | comment | added | Justin Cave | @SimonN - Of course, nothing guarantees that transactions are committed in any particular order. | |
| Jan 26, 2021 at 20:40 | comment | added | Simon Notley | Sequence values are always generated in order (with the exception of RAC) but does that guarantee that they'll be committed in order? Even if every transaction is just a single insert? | |
| Jan 26, 2021 at 20:17 | history | answered | Justin Cave | CC BY-SA 4.0 |