From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl> |
Cc: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: default locale considered harmful? (was Re: [GENERAL] |
Date: | 2003-06-05 21:59:23 |
Message-ID: | Pine.LNX.4.33.0306051555490.18636-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, 5 Jun 2003, Alvaro Herrera Munoz wrote:
> On Thu, Jun 05, 2003 at 09:44:21AM -0600, scott.marlowe wrote:
> > On Thu, 5 Jun 2003, Nigel J. Andrews wrote:
>
> > Everything Nigel just wrote plus one thing.
> >
> > If it comes down to it, we could always require a --locale setting and
> > refuse to initdb without it. That way, whether it's in an RPM or from
> > source, somebody somewhere along the line has to choose something.
>
> Yeah, that way the RPM guys would put the --locale taking the locale
> from the environment and you're back to ground zero.
>
> There's no point in forcing things down the throat of users using this
> kind of mechanisms, because someone is going to automate the thing
> along the way. What is needed is a way to make the user aware of his
> system's configuration.
But initdb IS different since it takes so much effort to change locales
once you've set up a cluster.
Unless the other locales can offer similar performance to the C locale, I
would suggest that we make the C locale the default. IF they need
something else they can change it after initdb.
If you're an old time user, you know how to set locale, and the
implications of a non-C locale, so a default of C is no big deal, and
you're likely to be looking at initdb to see the message telling you it's
using C.
If you're a beginner you likely need or want a locale of C, but don't know
it, and don't know that you can't change it without reinitdbing.
My only concern with going with a default locale of C is if it causes a
problem with data integrity (i.e. constraints that only behave right in a
certain locale).
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-06-05 23:33:30 | Re: Postgres config file: autocommit = off |
Previous Message | Alvaro Herrera Munoz | 2003-06-05 21:53:15 | Re: default locale considered harmful? (was Re: [GENERAL] |