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•14mo ago

Where do you get "users" from?

Cyber GrandmaOP•14mo ago

users is my table name

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

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

Pascal Mattes•14mo ago

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

Cyber GrandmaOP•14mo 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•14mo ago

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

Cyber GrandmaOP•14mo 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,
        .....
      },
    });