Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG]: drizzle seed breaks serial sequence sync with Postgres serial type #3915

Open
1 task done
kmate19 opened this issue Jan 7, 2025 · 1 comment
Open
1 task done
Labels
bug Something isn't working

Comments

@kmate19
Copy link

kmate19 commented Jan 7, 2025

Report hasn't been filed before.

  • I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.38.3

What version of drizzle-kit are you using?

0.30.1

Other packages

[email protected]

Describe the Bug

bug: currently, inserting data to a column with the serial type, drizzle seed doesn't seem to actually sync the sequence properly, causing data that's inserted after the seed to have a duplicate key issue.

reproduce:
simply seed a table with a serial primary key with some data, then try and insert some more data after the seed.

desired result:
drizzle seed should keep the serial sequence in sync.

@kmate19 kmate19 added the bug Something isn't working label Jan 7, 2025
@danilarb
Copy link

I'm also having this issue! Using Supabase

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants