Skip site navigation (1) Skip section navigation (2)

Re: locale changes

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches <pgsql-patches(at)postgreSQL(dot)org>
Subject: Re: locale changes
Date: 2000-07-20 15:31:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches
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:


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


 But, yes this solution is not in my patch. 


In response to


pgsql-hackers by date

Next:From: Jan WieckDate: 2000-07-20 15:39:14
Subject: Re: Hello PL/Python
Previous:From: Adriaan JoubertDate: 2000-07-20 15:24:57
Subject: Re: Loading binary data into the database

pgsql-patches by date

Next:From: Tom LaneDate: 2000-07-20 15:48:52
Subject: Re: locale changes
Previous:From: Tom LaneDate: 2000-07-20 15:16:23
Subject: Re: locale changes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group