159
SQLite (programming.dev)
submitted 2 months ago by tatterdemalion@programming.dev to c/programmer_humor@programming.dev
19 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[-] tatterdemalion@programming.dev 1 points 2 months ago

I believe both SERIALIZABLE and REPEATABLE READ isolation levels would raise an error for this example.

And I looked this up: Postgres won't retry the transaction for you either. Though ultimately I think this a good default behavior.

[-] FishFace@piefed.social 2 points 2 months ago

Why would repeatable read raise an error? I'm a little rusty but I thought it was only serialisable that could do, and that repeatable read simply ensured that the committed writes of transaction 2 would not be read in transaction 1, so it updating over the top of 2 is fine.

[-] tatterdemalion@programming.dev 2 points 2 months ago

I think you're right. An UPDATE would fail, but not an INSERT.

this post was submitted on 08 Nov 2025
159 points (97.6% liked)

Programmer Humor

29147 readers
276 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev