Comments (3)
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.
Related Issues (20)
- [BUG]: drizzle-orm dependency missing in drizzle-kit HOT 1
- [FEATURE]: Auto-Alias Columns in Subqueries
- [BUG]: drizzle-kit introspect casing "preserve" config not working
- [FEATURE]: add luxon datetime mode to timestamp columns
- [BUG]: string values for limit causes issues but for offset they are ok HOT 1
- [FEATURE]: Join type in query system when foreign key is nullable
- [BUG]: "Offset is outside the bounds of the DataView" when querying PgGeometry field via RQB relation HOT 1
- [BUG]: `drizzle-kit push --force` fails if `__old_push_table` doesn't exist
- [BUG]:isNotNull doesn't work with and statement that searches for a varchar with - HOT 1
- [FEATURE]: Ability to get info on migration status & if db can be migrated
- [BUG]: Not inferring types properly with typescript & turborepo HOT 1
- [FEATURE]: sqlx-ts integration for magic sql operator
- [BUG]: I get `cannot insert multiple commands into a prepared statement` when migrations more than one HOT 1
- [BUG]: ALTER TABLE Migration Fails to Preserve Default Value for Column
- [BUG]: permission denied for view pg_buffercache
- [BUG]:with clouse in query return never
- [FEATURE]: support const enums
- [BUG]: Issue with SQL generation. Trying to reference a type that doesn't exist? HOT 1
- [BUG]: No warning or error when performing a migration with duplicate table columns
- [BUG]: pg geometry is preventing migration
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from drizzle-orm.