Race conditions accidentally create nested transactions (and fail)

[fdietze]

(discord: https://discord.com/channels/632277896739946517/839844929877704785/999575181624352839)

Let's say, I have a function that does some queries in a transaction. Now, I connect to postgres with only a single connection. Then, I'm executing the function 10 times in parallel. What will happen?

Ideally, there is a Semaphore that serializes the execution of these 10 function calls.

But what's actually happening is, that you'll get a nested transaction error from skunk.