Nullable field cannot be inserted or updated

Hi! I've already broken my head, I've asked several ai chats why this might be an error, but they don't know why the error occurs

The problem is that I can't create/update the channels record's userId fields when the userId isn't set to .notNull()

When I bet .notNull() everything works for me, but I need the user Id to be an optional field

export const channels = pgTable('channels', {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  channelId: text('channelId').notNull().unique(),

  userId: integer('userId'),

  isActive: boolean('isActive').default(false).notNull(),

  createdAt: timestamp('created_at').notNull().defaultNow(),
  updatedAt: timestamp('updated_at').notNull().defaultNow(),
});

export const channelsRelations = relations(channels, ({ one }) => ({
  user: one(users, {
    fields: [channels.userId],
    references: [users.id],
  }),
}));

export const channels = pgTable('channels', {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  channelId: text('channelId').notNull().unique(),

  userId: integer('userId'),

  isActive: boolean('isActive').default(false).notNull(),

  createdAt: timestamp('created_at').notNull().defaultNow(),
  updatedAt: timestamp('updated_at').notNull().defaultNow(),
});

export const channelsRelations = relations(channels, ({ one }) => ({
  user: one(users, {
    fields: [channels.userId],
    references: [users.id],
  }),
}));

Thank you in advance for any hints :silly:

KrimaxOP•1/21/25, 8:22 PM

user.schema.ts

KrimaxOP•1/21/25, 8:24 PM

I found a closed issue that seems to relate directly to my problem
https://github.com/drizzle-team/drizzle-orm/issues/2654

GitHub

[BUG]: TypeScript error on optional fields during update (and inser...

What version of drizzle-orm are you using? 0.32.0 What version of drizzle-kit are you using? 0.23.0 Describe the Bug I've encountered a TypeScript error when trying to update an optional field ...

KrimaxOP•1/21/25, 8:26 PM

my tsconfig.json

KrimaxOP•1/21/25, 9:29 PM

who solved this problem?

TOSL•1/22/25, 4:27 AM

You added

Did you try also restarting you're TS language server?

TTOSL You added `strict: true?` Did you try also restarting you're TS language server...

KrimaxOP•1/22/25, 6:47 AM

Yes
the above is my config. I did everything that was offered in that issue on github

KrimaxOP•1/22/25, 7:45 AM

If you don't have such a problem, please upload your package versions