3 replies

Primary key is not applied

Drizzle doesn't generate a primary key statement in the migration. Here is the schema:

export const usersTable = pgTable(
  "users",
  {
    slackUserId: text().notNull(),
    slackTeamId: text().notNull(),
    tokenSet: jsonb().notNull(),
    createdAt: timestamp().notNull().defaultNow(),
  },
  (t) => [{ pk: primaryKey({ columns: [t.slackUserId, t.slackTeamId] }) }],
);

export const usersTable = pgTable(
  "users",
  {
    slackUserId: text().notNull(),
    slackTeamId: text().notNull(),
    tokenSet: jsonb().notNull(),
    createdAt: timestamp().notNull().defaultNow(),
  },
  (t) => [{ pk: primaryKey({ columns: [t.slackUserId, t.slackTeamId] }) }],
);

drizzle-kit: "^0.30.0"
drizzle-orm: "^0.38.0"

Drizzle Team•16mo ago•

3 replies

Eduard Dyckman

Primary key is not applied

Drizzle doesn't generate a primary key statement in the migration. Here is the schema:

export const usersTable = pgTable(
  "users",
  {
    slackUserId: text().notNull(),
    slackTeamId: text().notNull(),
    tokenSet: jsonb().notNull(),
    createdAt: timestamp().notNull().defaultNow(),
  },
  (t) => [{ pk: primaryKey({ columns: [t.slackUserId, t.slackTeamId] }) }],
);

export const usersTable = pgTable(
  "users",
  {
    slackUserId: text().notNull(),
    slackTeamId: text().notNull(),
    tokenSet: jsonb().notNull(),
    createdAt: timestamp().notNull().defaultNow(),
  },
  (t) => [{ pk: primaryKey({ columns: [t.slackUserId, t.slackTeamId] }) }],
);

drizzle-kit: "^0.30.0"
drizzle-orm: "^0.38.0"

Primary key is not applied

Similar Threads

Primary key is not applied

Similar Threads

Similar Threads

Similar Threads