On 4/16/19 2:04 PM, Zahir Lalani wrote:
> Hi
>
>> Is this the same for the other environments?
>
> We have recently upgraded others to 10 and are in testing before we upgrade production. However we still some 9.6 dev
serverswhich are fine.
I am not following above.
What is running version 10?
Did you restore a dump from a version 10 onto a version 9.6 machine?
>
>> What does:
>> SHOW lc_collate;
>
> en_US.UTF-8
The above is the same for all the servers?
>
>> Are you doing the below through Navicat or psql?
>
> Using Navicat for the test in all environments, but we have the same issue with app layer code connecting via perl
DBI.
>
> Z
>
--
Adrian Klaver
adrian.klaver@aklaver.com