Re: Sorting difference in version 10 vs 13

2021-12-20 Thread Ron
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();  

Re: Sorting difference in version 10 vs 13

2021-12-20 Thread Akheel Ahmed
Both are Amazon AWS Aurora instances. 10.x is on intel/amd64. 13.x is on their ARM based graviton. select version();    version -  

Re: Sorting difference in version 10 vs 13

2021-12-20 Thread Tom Lane
Akheel Ahmed 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

Sorting difference in version 10 vs 13

2021-12-20 Thread Akheel Ahmed
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