Re: Setting locale per connection

Behdad Esfahbod <behdad@bamdad.org>

From: Behdad Esfahbod <behdad@bamdad.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-07-02T10:03:54Z
Lists: pgsql-hackers
On Wed, 2 Jul 2003, Tom Lane wrote:

> > On Wed, 2 Jul 2003, Behdad Esfahbod wrote:
> >> so I have wrote my 10lines function as a wrapper around
> >> setlocale, that is attached.
> 
> Indeed, this is exactly why Postgres goes out of its way to prevent you
> from changing the backend's collation setting on-the-fly.  The proposed
> function is a great way to shoot yourself in the foot :-(.  If you doubt
> it, check the archives from two or three years ago when we did not have
> the interlock to force LC_COLLATE to be frozen at initdb time ...
> 
> 			regards, tom lane

So, assuming I want to go for the right way, I've just seen the 
column-based LC_COLLATE in the TODO list.  Is there any more 
information about that?

behdad

-- 
Behdad Esfahbod		11 Tir 1382, 2003 Jul 2 
http://behdad.org/	[Finger for Geek Code]

If you do a job too well, you'll get stuck with it.