Add unique constraint on (role_id, right_type) in OrgRoleRight

Fixkamo-shared-library
Shipped
April 20, 2026 at 8:02 PM UTC
Author
Kamo
Commit
1fd83c0

Required for ON CONFLICT DO NOTHING in **************** Without this constraint, the sync query fails with "no unique or exclusion constraint matching the ON CONFLICT specification", crashing SecurityService at startup.

All changes

Like what you see shipping?

Every one of these updates lands in your workspace automatically. Start free and watch it grow week after week.

Start Free ForeverView Pricing