TypeScript error when trying to insert rows without specifying primary key

[lenny-h]

Let's say I have the following Postgres table:

export const posts = pgTable("posts", {
  id: text("id").notNull().primaryKey(),
  userId: text("userId")
    .notNull()
    .references(() => users.id, { onDelete: "cascade", onUpdate: "cascade" }),
  createdAt: timestamp("createdAt", { mode: "date" }).defaultNow().notNull(),
});

Now I want to insert a new row in this table:

await db.insert(posts).values({
          userId: userId,
});

However, the above insertion doesn't work unless I specify an id. I guess I can generate a random id using for example the v4 method from uuid, but I would prefer not to if possible. Is it possible to have the primary key autogenerated when a new insertion is made?

[janvorwerk]

This is a great question for the "Ask AI" button at the top:

Enter your question: "Is it possible to have the primary key autogenerated when a new insertion is made?" and see the magic 🚀