Peter Eisentraut wrote: > Tom Lane wrote: > > It's certainly ungood, but I don't think we can materially improve > > things without a fundamental rewrite along the lines of Peter's > > proposal to support per-column locale/encoding. Database-level > > settings are simply the wrong tool for this. > > Well, the complete redo is about two years out if you ask me. Allowing > the locale to be set on a database level would already improve things a > lot for many people. Since we have a perfectly good reindex command, I > think the problems that we have discussed are not showstoppers.
I added a TODO item for fixing per-database locales, so we are ready if someone wants to code it: o Allow locale to be set at database creation -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend