I am using a migration file to add some indexes. W...
# prisma-migrates
sven
06/04/2021, 10:59 AMI am using a migration file to add some indexes. When I apply the migration (with prisma migrate dev), it creates another migration file where it drops the Indexes again… how can I add custom indexes?
j
janpio
06/04/2021, 5:44 PM
You run the migration with
migrate deployjanpio
06/04/2021, 5:45 PM
And then next time you use
migrate dev --create-onlyjanpio
06/04/2021, 5:45 PM
Are these indexes unsupported by Prisma? What is special about them?
s
sven
06/07/2021, 8:10 AMThey use the pg_trgm extension
sven
06/07/2021, 8:10 AM Copy code
CREATE INDEX index_on_profile_name_trigram ON "Profile" using gin (name gin_trgm_ops);sven
06/07/2021, 8:10 AMWhy do I have to remove the indexes again?
sven
06/07/2021, 8:11 AMI want them to persist
j
janpio
06/07/2021, 11:13 AM
Sorry, that was unclear - you have to remove the "removal of those indexes" again.
janpio
06/07/2021, 11:13 AM
As they are not in the Prisma Schema, Prisma Migrate will try to keep removing them.
janpio
06/07/2021, 11:14 AM
Please create an issue for these special indexes as a feature request so we can actually add support for them in the Prisma Schema and Prisma Migrate.
s
sven
06/07/2021, 2:55 PMsven
06/07/2021, 2:55 PMthanks for looking into it
sven
06/07/2021, 2:56 PMI also added, that it causes a drift, and so removes all my database content
j
janpio
06/07/2021, 2:57 PM
The drift is weird - as it makes the workaround impossible - we will try to reproduce that.
s
sven
06/07/2021, 4:31 PMThank you 🙂