I’m trying to use case-insensitive filter in Prism...
# orm-help
a
I’m trying to use case-insensitive filter in Prisma but after enabling the preview feature in the schema, I’m getting an error when I attempt to add mode: ‘insensitive’ to any queries. Tried to regenerate the client but that didn’t help. “Unknown arg ‘mode’”
n
Hey Aaron 👋 just to make sure, you're on a PostgreSQL database, right? Case insensitive queries are currently only supported for PostgreSQL. Also, if regenerating didn't work, you might want to
rm -rf node_modules
and then re-run
npm install
. If that doesn't help either, it would be great if you could create a GitHub issue so that our engineering team can look into the problem 🙂
a
Hey Nick, I’m using PostgreSQL 13. Tried removing node_modules too and honestly I’m not sure how to recreate the issue. All I know is that case-insensitive querying does not work. I’ll open up an issue.
I added a new issue Nick. Hopefully I’m just doing something wrong.