From Dev.to
Your UNIQUE constraint in PostgreSQL lets duplicates through. Here is how to find every one
The table has a UNIQUE constraint, and identical rows sit in it in pairs. If at least one column of the key is nullable, this is expected behaviour: following the SQL standard, PostgreSQL treats two N...