Re: Possible corrupt index?

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