Drizzle TeamDT
Drizzle Team•2y ago
georgeconst

Schema changes not detected by drizzle-kit generate:pg

Inside my 
mono-root/modules/@base/common/db/schema.ts
I have the following:
export * from "./schemas/address.js";

While my './schemas/address.js" looks like this:
import { pgTable, varchar, serial } from 'drizzle-orm/pg-core';

export const addresses = pgTable("addresses", {
  id: serial("id").primaryKey().notNull(),
  line1: varchar("address", { length: 512 }),
  line2: varchar("address", { length: 512 }),
  city: varchar("city", { length: 128 }),
  county: varchar("county", { length: 128 }),
  postalCode: varchar("postal_code", { length: 32 }),
})

export type SelectAddress = typeof addresses.$inferSelect;
export type InsertAddress = typeof addresses.$inferInsert;

Whenever I run the drizzle-kit generate:pg by running the following script (package.json script):
    "db:generate": "tsx ./db/index.ts --generate-config && tsx ./node_modules/drizzle-kit/bin.cjs generate:pg --config ./db/drizzle.config.json",

I get the "No schema changes, nothing to migrate 😴" with 
addresses 5 columns 0 indexes 0 fks
. Clearly, my 
addresses
table has 6 columns.
Was this page helpful?