pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Joe Conway <mail@joeconway.com>
Cc: Tristan Partin <tristan@neon.tech>
Cc: gdo@leader.it, pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG
Date: Mon, 12 Jun 2023 12:13:53 +0300
Message-ID: <49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi> (raw)
In-Reply-To: <574a1afa-5c6e-829c-0fed-a9ff44719f9f@joeconway.com>
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>

On 10/06/2023 22:28, Joe Conway wrote:
> On 6/10/23 15:07, Joe Conway wrote:
>> On 6/10/23 14:42, Tom Lane wrote:
>>> Joe Conway <mail@joeconway.com> writes:
>>>> 5/ The attached fixes the issue for me on pg10 and passes check-world.
>>>> Comments?
>>>
>>> The call in PGLC_localeconv seems *very* oddly placed.  Why not
>>> do that before it does any other locale calls?  Otherwise you don't
>>> really have reason to believe you're saving the appropriate
>>> values to restore later.
>>
>>
>> As far as I can tell it really only affects localeconv(), so I tried to
>> place it close to those. But I am fine with moving it up.
> 
> This version is against pg16 (rather than pg10), moves up that hunk,
> mentions localeconv() in the comment as the reason for the call, and
> fixes some whitespace sloppiness. I will plan to apply to all supported
> branches.
> 
> Better?

The man page for uselocale(LC_GLOBAL_LOCALE) says: "The calling thread's 
current locale is set to the global locale determined by setlocale(3)." 
Does that undo the effect of calling uselocale() previously, so if you 
later call setlocale(), the new locale takes effect in the thread too? 
Or is it equivalent to "uselocale(LC_ALL, setlocale(NULL))", so that it 
sets the thread's locale to the current global locale, but later 
setlocale() calls have no effect on it?

In any case, this still doesn't feel like the right place. We have many 
more setlocale() calls. Shouldn't we sprinkle them all with 
uselocale(LC_GLOBAL_LOCALE)? cache_locale_time() for example. Or rather, 
all the places where we use any functions that depend on the current locale.

How about we replace all setlocale() calls with uselocale()?

Shouldn't we restore the old thread-specific locale after the calls? I'm 
not sure why libperl calls uselocale(), but we are now overwriting the 
locale that it sets. We have a few other uselocale() calls in 
pg_locale.c, and we take care to restore the old locale in those.

There are a few uselocale() calls in ecpg, and they are protected by 
HAVE_USELOCALE. Interestingly, the calls in pg_locale.c are not, but 
they are protected by HAVE_LOCALE_T. Seems a little inconsistent.

-- 
Heikki Linnakangas
Neon (https://neon.tech)






view thread (38+ messages)  latest in thread

Message-ID: <49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi>
Permalink:  ../49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi/
Also on:    postgresql.org/message-id/49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: hlinnaka@iki.fi, mail@joeconway.com, tristan@neon.tech, tgl@sss.pgh.pa.us
  Subject: Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG
  In-Reply-To: <49dfcad8-90fa-8577-008f-d142e61af46b@iki.fi>
  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>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox