Case insensitive unique constraint

[mohaafaridd]

Problem

It's really important to keep the casing in some of our columns which are unique ( cannot be duplicated ) which constraint can be overridden so easily by just change the casing

Suggested solutions

I've found some articles and the most matching one is this
Within schema it'd be great having

model Blog {
	...
	name String @unique(mode:"insensitive")
}

Alternatives

The second solution which is the only available at the moment is to create another column with lowercased letters and it'll be the unique one

[pantharshit00]

This is more likely to be solved by citext support in schema. That will come eventually via #3447 although since citext is an extension instead of built in postgres type, it can take more time.

After that you could possibiliy do:

model Blog {
  ...
  name String @pg.Citext @unique
}

[probablycorey]

It doesn't look like #3447 supports a citext db type for postgres. Are there any plans to support the functionality that @Mohammed-Farid described?

[albertoperdomo]

@probablycorey Yes, we are adding support Citext as a type. This is scheduled for 2.16.0. I will also update #3447.

[albertoperdomo]

@Mohammed-Farid Does using Citext work for you as a solution?

[mohaafaridd]

@albertoperdomo Yes it should fix it as @pantharshit00 has shown previously