Unique / "already exists" errors when adding simple text field to schema

Questions and Answers
1
System Information
  • Strapi Version: 4.25.3
  • Operating System: macOS Sonoma 14.7
  • Database: Postgres
  • Node Version: v20.10.0
  • PNPM Version: 9.1.1
  • pg Version: ^8.13.0

I originally built my content models out in sqlite, but have since moved to Postgres. This means that all my data schemas were in place, Postgres connects well and I’m able to read and write data to these fields.

However, even adding a simple string fields to any schema now causes the same error, regardless of the schema. I try and edit. The error I get is this

 error: alter table "public"."home_pages_components" add constraint "home_pages_unique" unique ("entity_id", "component_id", "field", "component_type") - relation "home_pages_unique" already exists

The extra field could be something like this

"testOtherField": {
    "type": "string"
}

This happens on schemas not related to my home page schema.