Re: Index problem - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Index problem
Date
Msg-id Pine.LNX.4.21.0011152328500.779-100000@peter.localdomain
Whole thread Raw
In response to Re: Index problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index problem
List pgsql-sql
Tom Lane writes:

> We have talked about fixing this by saving the active LOCALE variables
> at initdb time, and having the postmaster adopt those values whenever
> it's started.  But it hasn't got done yet.  (Peter, would it be
> easy to make GUC handle this?  There'd need to be some way to cause
> guc.c to do a putenv() ...)

I thought pg_control was the place for this.  Any idea how long a locale
string can legally be?  Doesn't look too hard beyond that.

Then again, perhaps this should be a per-database thing, much like the
encoding.  The postmaster doesn't do any collating, so it should be safe
to have different locale in different backends. -- Unless someone puts an
index on pg_database.datname. :-)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index problem
Next
From: Tom Lane
Date:
Subject: Re: Index problem