Hung Nguyen Comments - Answer Overflow

Hung Nguyen

Posts Comments

DTDrizzle Team

•Created by Fabian B. on 1/15/2024 in #help

type "GEOMETRY(POINT)" does not exist

nvm, I am stupid... the PostGIS extension failed to install on our database... It works now...

12 replies

DTDrizzle Team

•Created by Fabian B. on 1/15/2024 in #help

type "GEOMETRY(POINT)" does not exist

could someone please help? here is how I leverage it

export const locations = pgTable('locations', {
    id: serial('id').primaryKey(),
    coordinate: point('coordinate'),
    api: locationApiType('api'),
});

export const locations = pgTable('locations', {
    id: serial('id').primaryKey(),
    coordinate: point('coordinate'),
    api: locationApiType('api'),
});

Migration file SQL

--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "locations" (
    "id" serial PRIMARY KEY NOT NULL,
    "coordinate" geometry(POINT),
    "api" "location_api_type"
);

--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "locations" (
    "id" serial PRIMARY KEY NOT NULL,
    "coordinate" geometry(POINT),
    "api" "location_api_type"
);

12 replies

DTDrizzle Team

•Created by Fabian B. on 1/15/2024 in #help

type "GEOMETRY(POINT)" does not exist

I also tried with @Fabian B. 's code above

12 replies

DTDrizzle Team

•Created by Fabian B. on 1/15/2024 in #help

type "GEOMETRY(POINT)" does not exist

I am facing the same issue, if I remove the double quotes, I still get the issue "PostgresError: type "geometry" does not exist"

12 replies

Gaming

Programming