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 servers which 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@xxxxxxxxxxx