On Jun 19, 2025, at 12:59, Thom Brown <t...@linux.com> wrote: > No. But given the options, I would personally choose nondeterministic > collations now that they are available. I just wish they were more > user-friendly as I suspect the majority of people either won't know about > them, or won't know how to use them.
I suspect there are a lot of uses of citext for databases created before nondeterministic collations existed and people are unaware of them or unclear on the migration path from one to the other, let alone implications for any infrastructure they built around cutest (like function signatures and return values). As long as citext conteinues to be maintained there and there’s no super clear path to migrate, I’d bet good money that few would bother to switch. Best, David
signature.asc
Description: Message signed with OpenPGP