> unless you're saying it would treat the previous "write" as a write for the read-within-transaction purpose
This is exactly what I'm proposing, since it's my experience with postgres. Starting to see that it's not what you all had in mind, and I can understand why 😅