Drizzle TeamDT
Drizzle Team•3y ago
Cyber Grandma

Insert or Update: Error undefined is not an object (evaluating 'col.name')

Hi, I'm trying to implement Insert or Update

export async function insertOrUpdateUser(user: UserInsert) {
  const db = await getDatabase();

  return await db
    .insert(users)
    .values(user)
    .onConflictDoUpdate({
      target: users.id,
      set: user
    });
}


I get this error:

TypeError: undefined is not an object (evaluating 'col.name')
      at /app/node_modules/drizzle-orm/pg-core/dialect.js:74:41
      at buildUpdateSet (/app/node_modules/drizzle-orm/pg-core/dialect.js:72:6)
      at onConflictDoUpdate (/app/node_modules/drizzle-orm/pg-core/query-builders/insert.js:57:19)
      at /app/src/db/schemas/users.ts:43:15
      at processTicksAndRejections (:61:76)


Any idea what it means ?
Was this page helpful?