make case insensitive schema.prisma

Someone know what typo that I have, cause I thought it should be possible.

6 Replies

harsh-harlequinOP•15mo ago

@db.Citext isn't working

provincial-silver•15mo ago

You need to install the extension to your database

harsh-harlequinOP•15mo ago

I tried yesterday, with shadow database and in the sql console at neon.tech but it didn't work sadly. I will try again today.

harsh-harlequinOP•15mo ago

I still do something wrong I think because it still doesn't work, I think I give up for now unless someone helps

harsh-harlequinOP•15mo ago

sensitive-blue•15mo ago

In the Neon console, go to the SQL editor in your project and run the following query:

CREATE EXTENSION IF NOT EXISTS citext;

CREATE EXTENSION IF NOT EXISTS citext;