undefined | Better HN

0 pointspsadauskas13y ago0 comments

Here's an UPSERT in postgresql: https://gist.github.com/paul/855efdecaaa2ec4deec7

While we're at it, here's a "find or create" in a single atomic statement: https://gist.github.com/paul/75ec84d131e36492b17b

0 comments

1 comments · 1 top-level

ocharles13y ago

I believe both of these still have race conditions, and are not the same as truly atomic upserts. Granted the window is considerably smaller, but their is still a race condition.

j / k navigate · click thread line to collapse