When adding a new participant to a space, we're encountering a database constraint violation if the participant name already exists in that space. We need to implement a check to prevent this error and handle duplicate names gracefully.
Current Behavior
Trying to add a participant with a name that already exists in a space results error:
Expected Behavior
Before adding a new participant, the system should check if the name already exists in the space. Depending on our product requirements, we should either:
Prevent duplicates and inform the user, or
Automatically modify the name to make it unique (e.g., by appending a number).
Description
Current Behavior
Expected Behavior