public inbox for [email protected]  
help / color / mirror / Atom feed
Re: glibc updarte 2.31 to 2.38
5+ messages / 5 participants
[nested] [flat]

* Re: glibc updarte 2.31 to 2.38
@ 2024-09-22 16:48  Paul Förster <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Paul Förster @ 2024-09-22 16:48 UTC (permalink / raw)
  To: Joe Conway <[email protected]>; +Cc: Peter J. Holzer <[email protected]>; [email protected]

Hi Joe

> On 22. Sep, 2024, at 15:47, Joe Conway <[email protected]> wrote:
> 
> Note that moving to ICU might improve things, but there are similar potential issues with ICU as well. The trick there would be to get your OS distro provider to maintain the same ICU version across major versions of the distro, which is not the case currently. Nor does the PGDG repo do that.

Then I strongly suggest that the PostgreSQL developers develop a fail safe sorting mechanism that holds for generations of locale changes.

Cheers,
Paul







^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: glibc updarte 2.31 to 2.38
@ 2024-09-22 16:53  Adrian Klaver <[email protected]>
  parent: Paul Förster <[email protected]>
  0 siblings, 3 replies; 5+ messages in thread

From: Adrian Klaver @ 2024-09-22 16:53 UTC (permalink / raw)
  To: Paul Förster <[email protected]>; Joe Conway <[email protected]>; +Cc: Peter J. Holzer <[email protected]>; [email protected]

On 9/22/24 09:48, Paul Förster wrote:
> Hi Joe
> 
>> On 22. Sep, 2024, at 15:47, Joe Conway <[email protected]> wrote:
>>
>> Note that moving to ICU might improve things, but there are similar potential issues with ICU as well. The trick there would be to get your OS distro provider to maintain the same ICU version across major versions of the distro, which is not the case currently. Nor does the PGDG repo do that.
> 
> Then I strongly suggest that the PostgreSQL developers develop a fail safe sorting mechanism that holds for generations of locale changes.

https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS

Add a builtin platform-independent collation provider (Jeff Davis)

This supports C and C.UTF-8 collations.

> 
> Cheers,
> Paul
> 
> 
> 

-- 
Adrian Klaver
[email protected]







^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: glibc updarte 2.31 to 2.38
@ 2024-09-22 18:44  Joe Conway <[email protected]>
  parent: Adrian Klaver <[email protected]>
  2 siblings, 0 replies; 5+ messages in thread

From: Joe Conway @ 2024-09-22 18:44 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; Paul Förster <[email protected]>; +Cc: Peter J. Holzer <[email protected]>; [email protected]

On 9/22/24 12:53, Adrian Klaver wrote:
> On 9/22/24 09:48, Paul Förster wrote:
>> Hi Joe
>> 
>>> On 22. Sep, 2024, at 15:47, Joe Conway <[email protected]> wrote:
>>>
>>> Note that moving to ICU might improve things, but there are similar potential issues with ICU as well. The trick there would be to get your OS distro provider to maintain the same ICU version across major versions of the distro, which is not the case currently. Nor does the PGDG repo do that.
>> 
>> Then I strongly suggest that the PostgreSQL developers develop a fail safe sorting mechanism that holds for generations of locale changes.
> 
> https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS
> 
> Add a builtin platform-independent collation provider (Jeff Davis)
> 
> This supports C and C.UTF-8 collations.


Yep, what he said

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






^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: glibc updarte 2.31 to 2.38
@ 2024-09-22 19:47  Peter J. Holzer <[email protected]>
  parent: Adrian Klaver <[email protected]>
  2 siblings, 0 replies; 5+ messages in thread

From: Peter J. Holzer @ 2024-09-22 19:47 UTC (permalink / raw)
  To: [email protected]

On 2024-09-22 09:53:58 -0700, Adrian Klaver wrote:
> On 9/22/24 09:48, Paul Förster wrote:
> > Then I strongly suggest that the PostgreSQL developers develop a
> > fail safe sorting mechanism that holds for generations of locale
> > changes.
> 
> https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS
> 
> Add a builtin platform-independent collation provider (Jeff Davis)
> 
> This supports C and C.UTF-8 collations.

Couldn't you always use "C" collation?

The problem with that is that most people[1] want stuff ordered
according to the rules of their language and C collation is in most
cases very different.

        hp

[1] I actually have LC_COLLATE=POSIX set in the shell. But I'm not
    normal.

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | [email protected]         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"


Attachments:

  [application/pgp-signature] signature.asc (833B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: glibc updarte 2.31 to 2.38
@ 2024-09-25 07:16  Paul Foerster <[email protected]>
  parent: Adrian Klaver <[email protected]>
  2 siblings, 0 replies; 5+ messages in thread

From: Paul Foerster @ 2024-09-25 07:16 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: Joe Conway <[email protected]>; Peter J. Holzer <[email protected]>; [email protected]

Hi Adrian,

> On 22 Sep 2024, at 18:53, Adrian Klaver <[email protected]> wrote:
> 
> https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS
> 
> Add a builtin platform-independent collation provider (Jeff Davis)
> 
> This supports C and C.UTF-8 collations.

I must admit that I haven't read the readme fully yet, but this is definitely great news. Thanks very much.

Cheers,
Paul





^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2024-09-25 07:16 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-22 16:48 Re: glibc updarte 2.31 to 2.38 Paul Förster <[email protected]>
2024-09-22 16:53 ` Adrian Klaver <[email protected]>
2024-09-22 18:44   ` Joe Conway <[email protected]>
2024-09-22 19:47   ` Peter J. Holzer <[email protected]>
2024-09-25 07:16   ` Paul Foerster <[email protected]>

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