Prisma•6mo ago

Prevent prisma from dropping custom index

How can I prevent prisma from trying to drop my custom index every time I try to run migrate dev?

CREATE INDEX idx_meterid_readingat_covering
ON "Reading" ("meterId", "readingAt")
INCLUDE ("value", "id", "createdAt", "updatedAt", "invoiceId");

CREATE INDEX idx_meterid_readingat_covering
ON "Reading" ("meterId", "readingAt")
INCLUDE ("value", "id", "createdAt", "updatedAt", "invoiceId");

4 Replies

Prisma AI Help•6mo ago

You chose to debug with a human. They'll tinker with your query soon. If you get curious meanwhile, hop into #ask-ai for a quick spin!

Nurul•6mo ago

Did you have a look at this issue? https://github.com/prisma/prisma/issues/12914 It's similar to what you are running into.

Nurul•6mo ago

Workaround - https://github.com/prisma/prisma/issues/12914#issuecomment-1713041472

GitHub

Prisma drops indexes defined outside of Prisma · Issue #12914 · p...

Problem I don't know if this is feature request or a bug report. When possible, developers should define indexes using Prisma schema language. However there are many scenarios where a developer...

NielsOP•6mo ago

Yes, although, this didn't help. When pulling the schema, it defines it wiithout the "include", and thus tries to drop my custom index again.

Gaming

Programming

Prevent prisma from dropping custom index

Did you find this page helpful?