47 replies

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,
  },
})

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

I have a target,

publishedTasks.taskId

publishedTasks.taskId

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

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

What am I doing wrong here?

Drizzle Team•2y ago•

47 replies

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,
  },
})

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

I have a target,

publishedTasks.taskId

publishedTasks.taskId

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

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

What am I doing wrong here?

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads