Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT query fails after pg_upgrade as the conditional operatorfails - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: SELECT query fails after pg_upgrade as the conditional operatorfails
Date
Msg-id adacc7ca-4cbc-7d8c-0b36-6603e10bb10a@a-kretschmer.de
Whole thread Raw
In response to SELECT query fails after pg_upgrade as the conditional operator fails  (Nithin Johnson <nithin.johnson@altair.com>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Nithin Johnson
Date:
Subject: SELECT query fails after pg_upgrade as the conditional operator fails
Next
From: Paul van der Linden
Date:
Subject: Re: Safe to delete files?