Re: Collation again here

On Thu, Jan 8, 2026 at 2:18 PM Rihad <grihad@gmail.com> wrote:
> We only have "i" & "c" in pg_collation. And we aren't using any of "i" it seems. All this locale/encoding/collate stuff is too much for me to handle, sorry)

As Daniel already told you, it's pg_database.datlocprovider that matters.

> So if we are using the internal (builtin) "c" provider how come the PG 18.1 run on FreeBSD 13.5 version shows warnings that the system version is 34.0?

"c" is NOT built-in. It's implemented thanks to the OS' libc as a dependency.
"b" is built-in, i.e. entirely within postgres, w/o external
dependencies (like icu or libc). New in PostgreSQL 18.

> Then upgrading (the OS from) 13.5 to 14.3 is our only option.

Given you're likely on "c", probably. As recommeded by Daniel. --DD