Composite unique constraint for specific values?

Question

Doctrine ORM

<unique-constraints>
                        <unique-constraint columns="is_enabled,is_default" name="unique_locale_default_enabled"/>
                        <unique-constraint columns="is_enabled,is_fallback" name="unique_locale_fallback"/>
        </unique-constraints>

Such code will naturally not work, because there are other locales, which are the majority, where both values ​​will be false.
Is there any way to check for uniqueness other than programmatically when updating the locale?

Answer 1

Solution, via Partial Unique Index with where
https://www.postgresql.org/docs/current/indexes-pa...
via Doctrine Annotations (Example with partial indexes)
https://www.doctrine-project.org/ projects/doctrine...