I encountered an issue while importing data from a CSV file into Supabase. Despite confirming that there are no duplicate primary keys in the CSV, I received the following error:
Failed to import data: Failed to run sql query: ERROR: 23505: duplicate key value violates unique constraint "cofounder_profiles_pkey" DETAIL: Key (slug)=(xIXcQdTMW) already exists.
Failed to import data: Failed to run sql query: ERROR: 23505: duplicate key value violates unique constraint "cofounder_profiles_pkey" DETAIL: Key (slug)=(xIXcQdTMW) already exists.
I have verified the CSV file and ensured that all slug values are unique. However, it seems like the import process is still identifying a conflict, suggesting there might be an underlying issue with how Supabase handles duplicates during the import.
Could this be a bug, or is there something else I may have missed? Any guidance or insights would be appreciated.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.