Re: Adding NetBSD and OpenBSD to Postgres CI - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Adding NetBSD and OpenBSD to Postgres CI
Date
Msg-id 2490325.1734471752@sss.pgh.pa.us
Whole thread Raw
In response to Re: Adding NetBSD and OpenBSD to Postgres CI  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> Andres Freund <andres@anarazel.de> writes:
>> It'd be helpful if the error message ought to at least include the category
>> being tested, perhaps it's just one category failing or such?

> Yeah, I will poke into this a little harder to see what's going on.

So after a little testing, setlocale(LC_COLLATE, ...) fails to set the
locale to (apparently) anything other than C, but it works for other
categories.  The reason is explained by "man setlocale":

     Currently, setlocale() returns NULL and fails to change the locale when
     LC_COLLATE is modified independently of other values.

It seems that on current NetBSD you have to use setlocale(LC_ALL, ...)
if you want to set the collation category.  That's quite annoying
from our perspective, but it's not something I'm excited about fixing.
Given other work going on, we might abandon all this logic soon
anyway.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING
Next
From: Andres Freund
Date:
Subject: Re: Exceptional md.c paths for recovery and zero_damaged_pages