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: Pine.LNX.3.96.1000720172144.11997S-100000@ara.zf.jcu.cz (view raw or flat)
Thread:
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:

	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		





In response to

Responses

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-2014 The PostgreSQL Global Development Group