Hacker News Reader

There's no 'CASE INSENSITIVE' option for unique indexes, but you can unique on lower(my_column) to achieve the safe effect.

yes that is what I do currently as a workaround. I wished we had an option for case-insensitive unique indexes though..