Postgis extension with Prisma migration
Hey Guys I have completely empty new DB. When I try to migrate init it causes error...
This is about postgis extension but I do not know how to fix it...
Any ideas?
SChema:
generator client {
provider = "prisma-client-js"
previewFeatures = ["postgresqlExtensions"]
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
extensions = [postgis, pg_graphql, pg_stat_statements, pgcrypto, supabase_vault, uuid_ossp(map: "uuid-ossp")]
}
model User {
user_id String @id
firstName String?
lastName String?
email String @unique
imageUrl String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
deletedAt DateTime?
isOnboarded Boolean @default(false)
restrictionStatus Int @default(0)
role Int @default(0)
locationPoint Unsupported("geometry(Point, 4326)")?
@@index([user_id])
@@index([firstName, lastName])
@@index([createdAt])
@@index([locationPoint], type: Gist)
}
generator client {
provider = "prisma-client-js"
previewFeatures = ["postgresqlExtensions"]
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
extensions = [postgis, pg_graphql, pg_stat_statements, pgcrypto, supabase_vault, uuid_ossp(map: "uuid-ossp")]
}
model User {
user_id String @id
firstName String?
lastName String?
email String @unique
imageUrl String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
deletedAt DateTime?
isOnboarded Boolean @default(false)
restrictionStatus Int @default(0)
role Int @default(0)
locationPoint Unsupported("geometry(Point, 4326)")?
@@index([user_id])
@@index([firstName, lastName])
@@index([createdAt])
@@index([locationPoint], type: Gist)
}
1 Reply
I also tried ONLY postgis extension but that had same exact error as well