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

[Andreas Kretschmer]

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