Drizzle Team•14mo ago

error: column "x" is in a primary key

I'm getting the following error, when trying to push my schema to my remote db: error: column "x" is in a primary key The weird thing is that everything works fine, when I drop all tables and run it for the first time, but if I try to re-run drizzle-kit push:pg, this is the error I get, even if the schema has not changed at all. Does anyone know what might cause this?

 {
  length: 109,
  severity: 'ERROR',
  code: '42P16',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '7287',
  routine: 'ATExecDropNotNull'
}

 {
  length: 109,
  severity: 'ERROR',
  code: '42P16',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '7287',
  routine: 'ATExecDropNotNull'
}

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

error: column "x" is in a primary key