Drizzle TeamDT
Drizzle Team•2y ago
benjick

there is no unique or exclusion constraint matching the ON CONFLICT specification

Having this issue that I've seen others also getting, but without explanation.

I'm only getting this error in production, not in my local dev environment.

.onConflictDoUpdate({
  target: publishedTasks.taskId,
  set: {
    showName: input.showName,
    showSchool: input.showSchool,
  },
})


I have a target, publishedTasks.taskId :

taskId: varchar("task_id")
  .primaryKey()
  .references(() => tasks.id, {
    onDelete: "cascade",
  })


What am I doing wrong here?
Was this page helpful?