pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Davis <pgsql@j-davis.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: Sandro Santilli <strk@kbt.io>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Regina Obe <lr@pcorp.us>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Order changes in PG16 since ICU introduction
Date: Tue, 09 May 2023 08:09:29 -0700
Message-ID: <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com> (raw)
In-Reply-To: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql>
References: <20230509082553.yjikrxn54mi6hezc@alvherre.pgsql>

On Tue, 2023-05-09 at 10:25 +0200, Alvaro Herrera wrote:
> I agree with removing these in v16, since they are going to become
> more
> meaningless and confusing.

Agreed, but it would be nice to have an alternative that does the right
thing.

It's awkward for a user to read pg_database.datlocprovider, then
depending on that, either look in datcollate or daticulocale. (It's
awkward in the code, too.)

Maybe some built-in function that returns a tuple of the default
provider, the locale, and the version? Or should we also output the
ctype somehow (which affects the results of upper()/lower())?

Regards,
	Jeff Davis






view thread (115+ messages)  latest in thread

Message-ID: <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com>
Permalink:  ../3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com/
Also on:    postgresql.org/message-id/3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: pgsql@j-davis.com, alvherre@alvh.no-ip.org, peter.eisentraut@enterprisedb.com, strk@kbt.io, tgl@sss.pgh.pa.us, lr@pcorp.us, pgsql-hackers@lists.postgresql.org
  Subject: Re: Order changes in PG16 since ICU introduction
  In-Reply-To: <3a00d1f05299d381dc701d283f95d845c741c6a1.camel@j-davis.com>

* 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