Postgres is adding a "unique nulls not unique" index, which prevents duplicate nulls. Normally a unique index allows duplicates if any column is null, so duplicate values of (123, null) are allowed. https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null