It would be really nice to use partial indexes and constraints in pg/cockroach. I don’t like that you now need to edit migration files manually. I want my entire schema to fit in schema.prisma.

Hi @Vasily Zorin 👋 There is a feature request for supporting partial indexes. You can leave a 👍 and a comment on these to help us prioritize it in the future. Also could you give us an idea of the kind of application you are building. Would you like to use the feature in production or development?

First in development, then in production 🙂