Database Transfer - Duplicate Key Error

[michaelstokes93]

Hello,

Hope you’re well!

I think we might be experiencing the same issue?

Duplicate key value violates unique constraint "[collection]_pkey"

Hello, Really enjoying working with Strapi but am currently facing an issue where we’re unable to add a new database record because of the following error: Duplicate key value violates unique constraint "[collection]_pkey" This seems to be happening with several tables. I’m not sure if it’s related to our manual import using a database tool ie… DataGrip. The only way to resolve it seems to delete all of the records of a table. We’re using PostgreSQL. Thanks for your help, Michael

Have you had any luck?