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

Thanks very much Juan for your quick reply. It helped us a lot. As suggested we have logged the following bug for pg_upgrade.

https://www.postgresql.org/message-id/15755-a5d9a0bea7ca931a@postgresql.org

Please look into it and let us know if any further details/info is needed.

Regards,
Suresh

From: Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
Date: Sunday, 14 April 2019 at 3:48 PM
To: Nithin Johnson <nithin(dot)johnson(at)altair(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Suresh Thelkar <suresh(dot)thelkar(at)altair(dot)com>, subhasis bhattacharya <subhasis(dot)bhattacharya(at)altair(dot)com>
Subject: Re: SELECT query fails after pg_upgrade as the conditional operator fails

I can use reindexing as a work around. Thanks!

Great!

If this is not something expected and if you need any more information on this issue please let me know.

No, this is not the expected behaviour, you can open a bug for pg_upgrade in order to find out where the problem comes from.

Regards,

Juan José Santamaría Flecha