Landry Breuil - Thu, 12 December 2019 at 08:51:49 > On Thu, Dec 12, 2019 at 01:47:25AM +0100, Jeremie Courreges-Anglas wrote: > > > > +cc maintainer > > > > This has bugged me for some time, I think enabling ICU makes sense. > > Here's a wip diff. I fear it might cause issues with existing > > databases. Real world tests would probably help. > > I doubt it can have side effects on existing databases as they all have > a locale (and potential collations) configured during initdb, and adding > the possibility to use more locales/collations shouldnt affect existing > ones. Of course, to be tested in the real world :)
initdb just sets "default" collation/ctype for `template1`. when collation/ctype needs to be different, `CREATE DATABASE` must use the template `template0`. Collation cannot be changed on a database after it has been created as it affects the index creation as well. -f -- why is the alphabet in that order? is it because of that song?