Ā© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
33 replies
rushil1o1

BUG: Postgres migration script generates a few syntax errors

Context: I was running migrations with drizzle-kit's migration function from
node-postgres
node-postgres
, and kept getting a lot of errors.

I had to make the following changes to the SQL script:
1. Add double quotes around table, index, and other field names
2. Array fields with default values just never generated the right code. So I had to manually add the default value in.

Screenshots show the full picture
Screen_Shot_2023-03-28_at_11.59.37_PM.png
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Migration Errors
Drizzle TeamDTDrizzle Team / help
17mo ago
Drizzle postgres migration gives lots of type errors
Drizzle TeamDTDrizzle Team / help
2y ago
postgres-js migration configuration
Drizzle TeamDTDrizzle Team / help
3y ago
migration on mysql errors
Drizzle TeamDTDrizzle Team / help
3y ago