drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
https://orm.drizzle.team
Apache License 2.0
21.52k stars 487 forks source link

[BUG]: postgis geometry error: type "geometry(point)" does not exist #2412

Closed MellKam closed 1 month ago

MellKam commented 1 month ago

What version of drizzle-orm are you using?

0.31.0

What version of drizzle-kit are you using?

0.22.0

Describe the Bug

When I try to use new geometry datatype for postgres and run the migrations I get an error: type "geometry(point)" does not exist

Generated sql looks like this:

CREATE TABLE IF NOT EXISTS "offline_conferences" (
    --> ...
    "coordinates" "geometry(point)" NOT NULL
);

Expected behavior

The output sql must not contain double quotes around the geometric data type

Environment & setup

No response

AndriiSherman commented 1 month ago

fixing

AndriiSherman commented 1 month ago

fixed in drizzle-kit@0.22.1