Hacker News Reader

Had a fascinating conversation with Claude about this (don't worry about the unhinged personality I gave it with preprompting):

https://gist.github.com/pmarreck/970e5d040f9f91fd9bce8a4bcee...

Pasted it there for brevity here. Also includes an easy way to export a Claude conversation (made with the help of Claude, of course).

View on HN

LLMs are not a great source for this type of information. This mess in no way articulated in what way savepoints and transactions are different.

Savepoints are fully equivalent to nested transactions with the constraint that only one is concurrently active. This limitation is just from the SQL standard programming model. At least in PostgreSQL implementation it would be reasonably simple to support multiple concurrent subtransactions. They are even called subtransactions internally.

What on Earth are you using as your system prompt!!?

LOL, it's amazing

Reply on news.ycombinator.com