I've tried just changing the parser to unconditionally casefold to upper.That's not the migration path I was thinking of.
First thing that happens is that initdb breaks. In addition, you have
potential issues with comparisons against the catalog's versions of
standard functions as such if you allow the case folding to be changed
after the catalogs are setup.
What I was thinking of was:
1. Have a setting, probably per-session. Per database works too.
2. Aside from the folder upper and folder lower, have a third option. This is "fold upper, if fails, fold lower. If succeeds, issue a warning". This should allow programs that rely on the folding (such as initdb) to be debugged during the transition period.
Shachar
-- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend