Allow creating GIN index on JSONB fields in Postgres adapter

[ansarizafar]

Problem

Prisma now allow filtering JSN fields but there is no way to create index on JSONB fields with schema definition language.

Suggested solution

Allow creating GIN index on JSONB fields in Postgres adapter with SDL.

[sourdzl]

does anyone have an example config of prisma not trying to drop a GIN index manually created directly in the database? i tried turning on extended features and adding a dummy @@Index, but couldn't figure out how to have prisma "ignore" the GIN index that wasn't specified in the schema file

[janpio]

That might not be possible right now 😞 As suggested in #12376 (comment), please describe your current experience in an issue please and we can look better into that. Thanks.

[janpio]

Internal note: https://github.com/prisma/database-schema-examples/search?q=%22USING+GIN%22

[sourdzl]

thank you @janpio for the quick response!

it would be good to update the docs, which suggest its possible - https://www.prisma.io/docs/concepts/components/prisma-client/full-text-search

[janpio]

This is now available in our dev version, so you can use prisma@dev and the extendedIndexes preview feature if you want to play with it. Optimally start with a db pull on your existing database that uses these, and see if they are added correctly to the introspected schema. Afterwards you can also play with adding additional ones and then migrate (with db push or migrate dev).

Let us know how it goes please!