Allowing Duplicate Email
Hello I have searched the community and all of the issues I saw are preventing duplicate emails. My issue is that I would like the user to generate a pdf report after entering their email. What is then happening is that if the user wants to generate additional reports then they will get an error message saying that the pdf report could not be generated due to duplicate emails.
Do you know how I can fix this issue?
Here is the error code I am getting:
Supabase error
Fetch error from https://epefjgmxngogjlteauue.supabase.co/rest/v1/marketing_emails?columns=%22email%22: {
"code": "23505",
"details": "Key (email)=(Nativetexanappraisal@gmail.com) already exists.",
"hint": null,
"message": "duplicate key value violates unique constraint "marketing_emails_email_key""
}
thanks
5 Replies
you have to remove the unique rule from your column . Just click on that column and click edit - then uncheck the unique
I apologize I am completely green and was using an LLM to create this site via prompts. Is this within supabase that I remove the rule from the column?
If you go into Table editor -> select marketing_emails table -> select column email and edit it
You should see this button to make it not unique