Re: locale changes

On Thu, 20 Jul 2000, Tom Lane wrote:

> Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
> > Now, possible is change locale environment from client without backend
> > restart and under one postmaster can run more backends with different
> > locale setting.
>
> No, no, NOOOOO!!!!
>
> This *will* destroy your database.
>
> Think about indexes on text columns. Change LOCALE, now the sort order

But, it is solvable, I save original start-up setting to serarate struct
that is never changed. All routines that can allow on-the-fly locale change
can use change-able structs and index (..etc.) can use original setting.

Now, locale (on-the-fly change-able locale) use formatting.c and money (may
be), all others routines can use start-up setting.

For example:

change_to_on_the_fly_locale_setting()
to_char();
set_original_locale();

... and SET LOCALE can be used for specific routines only.

Comments?

But, yes this solution is not in my patch.

Karel