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