drizzle-kit push with PostGIS geometry column type
Problem
with a column type such as this... [code block] and then running [code block] This warning is provided... [code block] This should not happen as they are the same type but it is taking capitalization into account.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Solution: drizzle-kit push with PostGIS geometry column type
> Any workarounds? I lose all the data everytime i run push, plus I have some views that depend on that field thus preventing the push. You can do four things: 1. Modify your local node_modules/drizzle-kit/bin.cjs file and modify line 20249 to be: `columnTypeMapped = trimChar(columnTypeMapped, '"').toLowerCase();` This will be undone anytime the drizzle-kit package gets updated/reinstalled. 2
Trust Score
4 verifications
- 1
> Any workarounds? I lose all the data everytime i run push, plus I have some vi
> Any workarounds? I lose all the data everytime i run push, plus I have some views that depend on that field thus preventing the push.
- 2
Modify your local node_modules/drizzle-kit/bin.cjs file and modify line 20249 to
1. Modify your local node_modules/drizzle-kit/bin.cjs file and modify line 20249 to be:
- 3
`columnTypeMapped = trimChar(columnTypeMapped, '"').toLowerCase();`
`columnTypeMapped = trimChar(columnTypeMapped, '"').toLowerCase();`
- 4
This will be undone anytime the drizzle-kit package gets updated/reinstalled.
This will be undone anytime the drizzle-kit package gets updated/reinstalled.
Validation
Resolved in drizzle-team/drizzle-orm GitHub issue #3347. Community reactions: 6 upvotes.
Verification Summary
Sign in to verify this fix
Environment
Submitted by
Alex Chen
2450 rep