Sorting difference in version 10 vs 13
Hi
I have performed logical replication from a 10.18 to 13.4.
in 13.4, order by asc gives underscores higher than other characters.
all the LC parameters are identical across both instances.
Am I missing anything else?
Help appreciated.
Thanks
Akheel Ahmed <akheel.mailing.list@gmail.com> writes:
in 13.4, order by asc gives underscores higher than other characters.
all the LC parameters are identical across both instances.
Am I missing anything else?
OS-level differences, perhaps?
https://wiki.postgresql.org/wiki/Locale_data_changes
regards, tom lane
Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on
their ARM based graviton.
select version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)
select version();
version
--------------------------------------------------------------------------------------------------
PostgreSQL 10.18 on x86_64-pc-linux-gnu, compiled by
x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)
Show quoted text
On 21/12/2021 3:12 pm, Tom Lane wrote:
Akheel Ahmed<akheel.mailing.list@gmail.com> writes:
in 13.4, order by asc gives underscores higher than other characters.
all the LC parameters are identical across both instances.
Am I missing anything else?OS-level differences, perhaps?
https://wiki.postgresql.org/wiki/Locale_data_changes
regards, tom lane
Aurora is sufficiently different from vanilla Postgresql that you need to
ask Amazon.
On 12/20/21 11:31 PM, Akheel Ahmed wrote:
Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on
their ARM based graviton.select version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)select version();
version
--------------------------------------------------------------------------------------------------
PostgreSQL 10.18 on x86_64-pc-linux-gnu, compiled by
x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit
(1 row)On 21/12/2021 3:12 pm, Tom Lane wrote:
Akheel Ahmed<akheel.mailing.list@gmail.com> writes:
in 13.4, order by asc gives underscores higher than other characters.
all the LC parameters are identical across both instances.
Am I missing anything else?OS-level differences, perhaps?
https://wiki.postgresql.org/wiki/Locale_data_changes
regards, tom lane
--
Angular momentum makes the world go 'round.