Theo's Typesafe Cult•12mo ago

Drizzle column does not exist

export const users = pgTable("users", {
  id: uuid("id").primaryKey().defaultRandom(),
  email: varchar("email", { length: 256 }).unique().notNull(),
  createdAt: timestamp("created_at").defaultNow().notNull(),
  hash: text("hash").notNull(),
  salt: text("salt").notNull(),
});

export const users = pgTable("users", {
  id: uuid("id").primaryKey().defaultRandom(),
  email: varchar("email", { length: 256 }).unique().notNull(),
  createdAt: timestamp("created_at").defaultNow().notNull(),
  hash: text("hash").notNull(),
  salt: text("salt").notNull(),
});

Keep getting these error when i add new columns into my users table, removing the column salt works but when i add another column such as

  updatedAt: timestamp("updated_at").defaultNow().notNull(),

  updatedAt: timestamp("updated_at").defaultNow().notNull(),

i keep getting the same error i am using postgres locally with docker any idea? thanks!

2 Replies

Driano•12mo ago

Have you run the db push command? Also, how is your drizzle config file?

shivam•12mo ago

can you give me the terminal error

Gaming

Programming

Drizzle column does not exist