Open Bug 300417 Opened 19 years ago

[PostgreSQL] Case-insensitive Uniqueness can be cheaply enforced with a UNIQUE index

Categories

(Bugzilla :: Database, defect)

2.20
defect
Not set
normal

Tracking

()

People

(Reporter: mkanat, Unassigned)

References

Details

Right now, MySQL is entirely case-insensitive when you use the "=" operator or
similar operators.

Actually, PostgreSQL just uses the current character set, but I'm not aware of a
charset that has a case-insensitive collation that we could use.

Basically, this means that anywhere that we need things to be unique in a
case-insensitive fashion, PostgreSQL won't pick up.

However, we can cheaply enforce this with indexes on columns like:

LOWER(name), component_id
Blocks: meta-pg
You need to log in before you can comment on or make changes to this bug.