Shaheed,
How often do you sort words in text editors?
How often do you have your text editor care whether the word you just typed is the only instance of that word in the document?
Not too often. So... yes, we ignore the problem.
The real question is why nobody notices it in other RDBMSs like Oracle, SQL Server and MySQL.
I've been working on Unix-like systems for decades and though I thought I understood most of the issues to do with i18n/l10n, I've only just started using Postgres and I don't understand is why these changes ONLY seem to affect Postgres. Or is it more that it also affects text editors and the like, but we just tend to ignore that?
On 9/21/24 15:19, Paul Foerster wrote:
> I already expressed the idea of changing all locales to ICU. The
> problem there is that I'd have to create new instances and then move
> each database individually. I wish I could convert already running
> databases… This also takes time. Still, I think I'm going to try
> this route. It's always a gamble if reindexing is needed or not with
> any glibc change.
Note that moving to ICU might improve things, but there are similar
potential issues with ICU as well. The trick there would be to get your
OS distro provider to maintain the same ICU version across major
versions of the distro, which is not the case currently. Nor does the
PGDG repo do that.
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
-- Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
