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
    });
}

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)

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 ?

15 Replies

Pascal Mattes•2y ago

Where do you get "users" from?

Cyber GrandmaOP•2y ago

users is my table name

export const users = pgTable('users', {...

export const users = pgTable('users', {...

Pascal Mattes•2y ago

Okay so you do import users in the file where the function "insertOrUpdateUser" is?

Cyber GrandmaOP•2y ago

Yes, it's in the same exact file There is no TS Error at transpile time, the errors comes from within drizzle's module

Pascal Mattes•2y ago

Okay. We are doing this the exact same way and for us it is working. Thats why i was asking 🙂

Cyber GrandmaOP•2y ago

mmh If I do that:

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

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