© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•6mo ago•
1 reply
Irakli

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)
}
Screenshot_2025-08-22_at_13.35.31.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Issue with Database Connection / Prisma Migration
SupabaseSSupabase / help-and-questions
14mo ago
Why Use a Dedicated gis Schema for PostGIS extension?
SupabaseSSupabase / help-and-questions
13mo ago
reading postgis points with supabase
SupabaseSSupabase / help-and-questions
4y ago
Extension Update error when running migration
SupabaseSSupabase / help-and-questions
3y ago