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,