11 replies

type "GEOMETRY(POINT)" does not exist

Hi there! I try to use PostGIS with drizzle and having a hard time. I try to run the following migration file

ALTER TABLE "locations" ADD COLUMN "geoPoint" "GEOMETRY(POINT)";

ALTER TABLE "locations" ADD COLUMN "geoPoint" "GEOMETRY(POINT)";

But it errors with

PostgresError: type "GEOMETRY(POINT)" does not exist
    at ErrorResponse (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:790:26)
    at handle (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:476:6)
    at Socket.data (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42704',
  position: '47',
  file: 'parse_type.c',
  line: '270',
  routine: 'typenameType'
}

PostgresError: type "GEOMETRY(POINT)" does not exist
    at ErrorResponse (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:790:26)
    at handle (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:476:6)
    at Socket.data (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42704',
  position: '47',
  file: 'parse_type.c',
  line: '270',
  routine: 'typenameType'
}

Even though PostGIS is setuped successfully. When I run this SQL in supabase directly, it correctly adds the new column with the special data type.

I'm not the only one: https://github.com/drizzle-team/drizzle-orm/issues/1315

Maybe someone has an idea, would be grateful!

GitHub

[BUG]: 'type "geography(Point)" does not exist' when using push:pg ...

What version of drizzle-orm are you using? 0.28.6 What version of drizzle-kit are you using? 0.19.13 Describe the Bug drizzle-kit push:pg does not complete when using a custom type and trying to pu...

Drizzle Team•3y ago•

11 replies

Fabian B.

type "GEOMETRY(POINT)" does not exist

Hi there! I try to use PostGIS with drizzle and having a hard time. I try to run the following migration file

ALTER TABLE "locations" ADD COLUMN "geoPoint" "GEOMETRY(POINT)";

ALTER TABLE "locations" ADD COLUMN "geoPoint" "GEOMETRY(POINT)";

But it errors with

PostgresError: type "GEOMETRY(POINT)" does not exist
    at ErrorResponse (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:790:26)
    at handle (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:476:6)
    at Socket.data (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42704',
  position: '47',
  file: 'parse_type.c',
  line: '270',
  routine: 'typenameType'
}

PostgresError: type "GEOMETRY(POINT)" does not exist
    at ErrorResponse (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:790:26)
    at handle (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:476:6)
    at Socket.data (file:///Users/fabian/<redacted>/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:324:12)
    at readableAddChunk (node:internal/streams/readable:297:9)
    at Readable.push (node:internal/streams/readable:234:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42704',
  position: '47',
  file: 'parse_type.c',
  line: '270',
  routine: 'typenameType'
}

GitHub

[BUG]: 'type "geography(Point)" does not exist' when using push:pg ...

type "GEOMETRY(POINT)" does not exist

type "GEOMETRY(POINT)" does not exist

Similar Threads

Similar Threads

Similar Threads