Horton

Re: Move defaults toward ICU in 16?

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es
From: Jeff Davis <pgsql@j-davis.com>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Andres Freund <andres@anarazel.de>, Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Thomas Munro <thomas.munro@gmail.com>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org, Heikki Linnakangas <hlinnaka@iki.fi>, Michael Meskes <meskes@postgresql.org>
Date: 2023-03-08T05:55:07Z
Lists: pgsql-hackers 
On Fri, 2023-03-03 at 21:45 -0800, Jeff Davis wrote:
> > >    0002: update template0 in new cluster (as described above)

I think 0002 is about ready and I plan to commit it soon unless someone
has more comments.

I'm holding off on 0001 for now, because you objected. But I still
think 0001 is a good idea so I'd like to hear more before I withdraw
it.

> > >    0003: default initdb to use ICU

This is also about ready, and I plan to commit this soon after 0002.

> A different issue: unaccent is calling t_isspace(), which is just not
> properly handling locales. t_isspace() always passes NULL as the last
> argument to char2wchar. There are TODO comments throughout that file.

I posted a bug report and patch for this issue:

https://www.postgresql.org/message-id/79e4354d9eccfdb00483146a6b9f6295202e7890.camel@j-davis.com


Regards,
	Jeff Davis

Commits

  1. Build ICU support by default.

  2. Use ICU by default at initdb time.

  3. pg_upgrade: copy locale and encoding information to new cluster.