Unique partial indexes with PostgreSQL
Using unique partial indexes to avoid conditional duplication can save you a lot of effort when dealing with concurrency.
https://medium.com/little-programming-joys/unique-partial-indexes-with-postgresql-86e137905c12
Post a comment