News for hackers. Stuff that matters.
Re:SQL Needed Structure by andyferris on Friday September 05, 2025 @08:23AM (#45137697)
> a transaction doesn't guarantee that all statements in it see the data at the same point in time

This depends on the transaction isolation level. If you use snapshot or serializable this should be the case (but you may have aborted transactions due to optimistic concurrency).

Re:SQL Needed Structure by Spixel_ on Friday September 05, 2025 @10:50AM (#45139249)
You are right, but note that the default isolation level is "Read committed" in postgres.