Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8
Date: Fri, 09 Jun 2023 10:31:14 -0500
Message-Id: <CT887GSPI31W.BQCSW35JL67L@gonk>
Cc: <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG
To: "Heikki Linnakangas" <hlinnaka@iki.fi>, "Tom Lane" <tgl@sss.pgh.pa.us>,
 <gdo@leader.it>
From: "Tristan Partin" <tristan@neon.tech>
References: <17946-3e84cb577e9551c3@postgresql.org>
 <1564676.1685043220@sss.pgh.pa.us>
 <555bb26e-c27c-ab65-028f-3fd5b82df9de@iki.fi>
In-Reply-To: <555bb26e-c27c-ab65-028f-3fd5b82df9de@iki.fi>
Archived-At: 
 <https://www.postgresql.org/message-id/CT887GSPI31W.BQCSW35JL67L%40gonk>
Precedence: bulk

On Mon Jun 5, 2023 at 11:00 AM CDT, Heikki Linnakangas wrote:
> On 25/05/2023 15:33, Tom Lane wrote:
> > PG Bug reporting form <noreply@postgresql.org> writes:
> >> After upgrading an application using Postgresql from version 10 to 12,
> >> fields of type "money" are no longer generated with the =E2=82=AC symb=
ol but with
> >> $.
> >=20
> > Hmm, seems to work for me:
>
> I can reproduce this:
>
> psql (16beta1)
> Type "help" for help.
>
> postgres=3D# DO LANGUAGE 'plperl' $$ elog(NOTICE, 'foo') $$;
> NOTICE:  foo
> DO
> postgres=3D# SET lc_monetary TO 'en_GB.UTF-8';
> SET
> postgres=3D# SELECT 12.34::money AS price;
>   price
> --------
>   $12.34
> (1 row)
>
>
> If I don't call the plperl function, it works as expected:
>
> sql (16beta1)
> Type "help" for help.
>
> postgres=3D# SET lc_monetary TO 'en_GB.UTF-8';
> SET
> postgres=3D# SELECT 12.34::money AS price;
>   price
> --------
>   =C2=A312.34
> (1 row)
>
> I should note that 'en_GB.UTF-8' is the default locale in my system, and=
=20
> that's what I used in initdb. I don't know if it makes a difference.

I am looking into this bug. I have also reproduced it.

--=20
Tristan Partin
Neon (https://neon.tech)