PostgREST can't upsert against partial unique indexes (opens in new tab)

The bug I split a 3-column unique constraint into two partial unique indexes to support a new nullable column. The next day, every .upsert() against that table started failing with: there is no unique or exclusion constraint matching the ON CONFLICT specification The upsert call hadn't changed. The data shape was identical. The error message was technically correct and completely useless: the constraint did exist, it was just partial. This post is the unblock for anyone hitting that error on ...