Message-ID: <18c6979a-126a-e530-7cc4-3b6984b1997b@joeconway.com>
Date: Mon, 12 Jun 2023 17:28:52 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG
Content-Language: en-US
From: Joe Conway <mail@joeconway.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Tristan Partin <tristan@neon.tech>, gdo@leader.it,
 Tom Lane <tgl@sss.pgh.pa.us>,
 PostgreSQL-development <pgsql-hackers@postgreSQL.org>
References: <17946-3e84cb577e9551c3@postgresql.org>
 <1564676.1685043220@sss.pgh.pa.us>
 <555bb26e-c27c-ab65-028f-3fd5b82df9de@iki.fi>
 <CT887GSPI31W.BQCSW35JL67L@gonk>
 <ca35e375-be82-322d-8c81-78127d8fb33f@joeconway.com>
 <5676b739-0854-f924-4b97-466e3504c692@joeconway.com>
 <f1856a5d-3703-66ff-e7c7-01d2489315c1@joeconway.com>
 <665279.1686422574@sss.pgh.pa.us>
 <c23d6ec1-f882-af48-82d9-54e9f3e15809@joeconway.com>
 <574a1afa-5c6e-829c-0fed-a9ff44719f9f@joeconway.com>
 <49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi>
 <41a4898e-1cdb-960d-f17e-d71886407e04@joeconway.com>
In-Reply-To: <41a4898e-1cdb-960d-f17e-d71886407e04@joeconway.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/18c6979a-126a-e530-7cc4-3b6984b1997b%40joeconway.com>
Precedence: bulk

On 6/12/23 10:44, Joe Conway wrote:
> 1/ how do we fix the misbehavior reported due to libperl in existing
> stable branches

<snip>

> I was mostly trying to concentrate on #1, but 2 & 3 are worthy of
> discussion.

Hmm, browsing through the perl source I came across a reference to this 
(from https://perldoc.perl.org/perllocale):

---------------
PERL_SKIP_LOCALE_INIT

     This environment variable, available starting in Perl v5.20, if set 
(to any value), tells Perl to not use the rest of the environment 
variables to initialize with. Instead, Perl uses whatever the current 
locale settings are. This is particularly useful in embedded 
environments, see "Using embedded Perl with POSIX locales" in perlembed.
---------------

Seems we ought to be using that.

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com