PrismaP
Prisma•12mo ago•
9 replies
tyler4949

ConnectorError after moving to Prisma Postgres

I am in the process of migrating from a Neon postgres db to a Prisma Postgres db. I followed the migration docs to transfer my data and table structure: https://www.prisma.io/docs/getting-started/prisma-postgres/import-from-existing-database-postgresql

After doing this, I am able to load all data, but any delete or update is failing with this error:

Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "55000", message: "cannot delete from table \"_RecipeToRecipeCategory\" because it does not have a replica identity and publishes deletes", severity: "ERROR", detail: None, column: None, hint: Some("To enable deleting from the table, set REPLICA IDENTITY using ALTER TABLE.") }), transient: false })


Here is the schema I am using: https://github.com/tylerpashigian/t3-recipe-book/blob/main/prisma/schema.prisma

Does anyone know why I'm getting this error and how I can fix it? Everything I am seeing points to my schema not being set up propely (likely a table missing an @id?), but I'm curious how this worked fine on my previous db.
Was this page helpful?