You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We soft delete customers, but the unique index on organization_id and email prevents the email from being freed up for a new customer.
Expected Behavior
We could probably solve this by modifying the index to include the deleted_at timestamp. Causing a unique violation in case of creating a customer with the same email as an existing – non-deleted – customer, but not in case others have a unique deleted_at timestamp.
The text was updated successfully, but these errors were encountered:
Description
We soft delete customers, but the unique index on
organization_id
andemail
prevents the email from being freed up for a new customer.Expected Behavior
We could probably solve this by modifying the index to include the
deleted_at
timestamp. Causing a unique violation in case of creating a customer with the same email as an existing – non-deleted – customer, but not in case others have a unique deleted_at timestamp.The text was updated successfully, but these errors were encountered: