MUG Knight
DTDrizzle Team
•Created by MUG Knight on 10/7/2024 in #help
Adding record in Drizzle Studio with .generatedAlwaysAsIdentity error.
I have a table with a primary key column, defined as the following:
id: bigint("id", { mode: "number" })
.primaryKey()
.generatedAlwaysAsIdentity({ startWith: 1000 }),
If I try to add an item into the table via Drizzle Studio, I get the following error:
"cannot insert a non-DEFAULT value into column "id""
I can't find a combination of options/data entry to make this work. Any ideas?
2 replies