Re: [18] separate collation and ctype versions, and cleanup of pg_database locale fields - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [18] separate collation and ctype versions, and cleanup of pg_database locale fields
Date
Msg-id 09d73e33880d593203229d3948629b97f2bb2ea1.camel@j-davis.com
Whole thread Raw
In response to [18] separate collation and ctype versions, and cleanup of pg_database locale fields  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
On Thu, 2024-07-25 at 13:29 -0700, Jeff Davis wrote:
> it may be a good idea to version collation and ctype
> separately. The ctype version is, more or less, the Unicode version,
> and we know what that is for the builtin provider as well as ICU.

Attached a rough patch for the purposes of discussion. It tracks the
ctype version separately, but doesn't do anything with it yet.

The main problem is that it's one more slightly confusing thing to
understand, especially in pg_database because it's the ctype version of
the database default collation, not necessarily datctype.

Maybe we can do something with the naming or catalog representation to
make this more clear?

Regards,
    Jeff Davis


Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: why is pg_upgrade's regression run so slow?
Next
From: Dave Cramer
Date:
Subject: Re: Protocol question regarding Portal vs Cursor