-
Notifications
You must be signed in to change notification settings - Fork 16
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
Support for PostgreSQL PostGIS with DB push #350
Comments
I'm also experiencing this issue e.g the generated SQL looks like:
with geometry in quotations |
I am also having this issue. We are having to manually remove the quotes which is a pain. I would offer a patch to the tool however the drizzle-kit source does not seem to be generally available? 😅 |
It looks like drizzle-kit 0.22 has added
Looks like geometry(Geometry) might work though. Passes my tests anyway. The drizzle-kit update doesn't support box2d/box3d columns in case anyone is using that. FWIW I've been trying to get this stuff working over at https://github.com/Schmavery/drizzle-postgis in case that helps anyone. |
When attempting to use the PostgreSQL PostGIS
geometry
data type,drizzle-kit
will currently quote it and break the ability to use DB push.This is the custom type I am trying to use:
This is the generated SQL:
The issue comes specifically from this line in the Drizzle Kit code:
Either extend
isPgNativeType
to include geometry as a native type or add support for using thesql
orsql.raw
as part of thedataType
return.This would make using drizzle with geospatial data usable.
The text was updated successfully, but these errors were encountered: