Hacker News new | ask | show | jobs
by anarazel 4 days ago
> Well also I know Postgres UNIQUE indexes provide additional locking. Like you can do an INSERT... WHERE NOT EXISTS or INSERT... ON CONFLICT that is guaranteed to succeed.

That's true only for the latter (and even then only at a isolation level that's not too strict).

1 comments

Oh I misremembered, yeah just tested and the second INSERT errors.