[BUG]: Duplicate entry for auto increment column when execute insert statement about drizzle-orm HOT 3 OPEN

I got same problem on postgres. It is doing duplicate. It should not even try to add id, database should do it.

from drizzle-orm.

What do you mean by duplicate entry? Why writing default is wrong?

from drizzle-orm.

What do you mean by duplicate entry? Why writing default is wrong?

This is actually easy to replicate on Postgres.

• create new table
• add bunch of data to it (manually or via some script) but with ids (this is actually real life scenario, when you migrate/clone data from one server to another or similar), for test case id in each or some records must be present.
• try to add one or more records via Drizzle

you will get error that PK already exists, since sequence on PK (for example id) is out of order.

So you need fix sequence first with:

SELECT setval('SCHEMA.SEQUENCE_NAME', max(id) + 1) FROM SCHEMA.TABLE;

So at the end this is not drizzle problem in some sense, but db issue somehow. I was expecting more from Postgres :)

I was able to reslove this by fixing sequence.

from drizzle-orm.