Re: SELECT query fails after pg_upgrade as the conditional operator fails

[Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>]

Am 13.04.19 um 11:22 schrieb Nithin Johnson:
> We are seeing this intermittent problem after we upgrade (using 
> pg_upgrade) from postgres 9.3.12 to 9.6.12
>
> Querying  few of the rows in the table using a TEXT field is failing.

sounds like a corrupt index, can you show us the complete error message 
and the table definition?


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com