I’m trying to add pg_trgm and relevant index for fuzzysearch in postgresql. Following the advice from full-text-search documentation page, I added the index manually from an empty migration file like this. According to the documentation it’s supposed to ignore the unknown indexes, but it doesn’t. It forces create a migration that drop the index for me. Anyone knows a way around this?

Hey Ethan 👋 What Prisma version are you using?

Hi @Nurul thank you for responding.

"@prisma/client": "^3.0.2",

Which commands did you run to create the empty migration file? Can you check this customizing migrations guide and see if you followed these steps?

I ran this command

npx prisma migrate dev --create-only

which creates an empty migration file. Then I run

npx prisma migrate dev

to migrate which is when it creates the drop index migration file automatically.

I am also having this issue, did you ever find a solution?