[email protected] (HE12025-12-23): > Hm. In the general or in the specific?
I do not understand the question. > I don't know how a database could build a text index without taking into > account locales (especially, but not only collation). > > At index creation you may, of course, state which, but it will inherit > its default from template1, and this one is set at cluster creation > (which, for Debian, happens at package -- first -- install). > > What would be your aprproach to do it better? (1) Sanitize the environment when starting the cluster so as not to let the weird settings from the system or, even worse, the user who started the init script, affect its workings. (2) Use explicit settings with each a specific meaning? One setting for the collation rules, etc. (3) To implement it, use a library with a dedicated interface, not hack that changes the behaviour of standard library functions in a system-dependant way. Regards, -- Nicolas George
