Prisma Schema: make postgresqlExtensions GA

[Jolg42]

• Check issues with postgresqlExtensions topic tag
• Check Preview feature feedback: PostgreSQL extensions #15835
• Features/improvements
  • [PostgreSQL] - setting a schema clobbers the postgresql search_path instead of prepending to search_path #14662
  • Add uuid-ossp extension to postgres automatically #6822
  • Migrate diffing: ignore potentially-postgis tables for diffing only in the schema where the extension is installed #15363
  • Deal with extensions that are not installed/present #15888
  • [postgresqlExtensions] consider a destructive change check for dropped-and-recreated extensions in Migrate #15795
• Bugs
  • Confirmed
    • Nested disconnect fails on MongoDB with extendedWhereUnique #16869
    • supabase/when using with multiSchema Drift detected: Your database schema is not in sync with your migration history - every migration on Supabase #19100
    • prisma db push Error - Database error: Error querying the database: db error: ERROR: type "citext" does not exist but citext extension enabled  #6944
  • To reproduce
    • Update fails when querying nullable field with "not" operator when field is NULL using extendedWhereUnique #16880
    • Installing extension pg_cron in shadow db migration fails #18214
  • To Close?
    • Creating custom migration to apply extension results in "extension does not exist" #13428
    • Migration failed on ERROR: type "geometry" does not exist #7455
    • uuid_generate_v4() error after the first migration is passed #10912
    • Can't find uuid_generate_v4() function despite extension being installed #19144
• Deprecate preview feature flag
• Inform and close Preview feature feedback: PostgreSQL extensions #15835
• Update docs Prisma Schema Docs: make postgresqlExtensions GA docs#4856
• Anything else?

[Jolg42]

Note: Making the feature GA, is not part of Prisma 5.0.0 planning anymore.

[NickG-NZ]

This is not part of Prisma 5? How are we supposed to deal with this now? I have essentially the same issue as #10912 .

I introspected the DB and successfully generated my first migration file, but now I can't create any new ones.
Is the preview feature supposed to be available still? It doesn't seem to work, the Shadow DB still doesn't find the extension

[Jolg42]

@NickG-NZ I updated the comment.
You must add the preview feature postgresqlExtensions, the feature is still available but requires the preview feature flag.
If you are experiencing an issue, please open a new issue and provide the information needed, so we can help you.