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

To: Nithin Johnson <nithin.johnson@xxxxxxxxxx>
Subject: Re: SELECT query fails after pg_upgrade as the conditional operator fails
From: Juan José Santamaría Flecha <juanjo.santamaria@xxxxxxxxx>
Date: Sun, 14 Apr 2019 12:17:48 +0200
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx, Suresh Thelkar <suresh.thelkar@xxxxxxxxxx>, Subhasis Bhattacharya <subhasis.bhattacharya@xxxxxxxxxx>
In-reply-to: <MN2PR03MB478277A793A7A632DB311A89F52A0@MN2PR03MB4782.namprd03.prod.outlook.com>
References: <MN2PR03MB47823472BA52EDB96DFA58C6F5290@MN2PR03MB4782.namprd03.prod.outlook.com> <CAC+AXB2qE9ZF8MZZ=OSEfg6ufKuGBn-6ZzNwT-iAJhE5UHOh7g@mail.gmail.com> <MN2PR03MB478277A793A7A632DB311A89F52A0@MN2PR03MB4782.namprd03.prod.outlook.com>

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

Follow-Ups:
- Re: SELECT query fails after pg_upgrade as the conditional operator fails
  - From: Suresh Thelkar

References:
- SELECT query fails after pg_upgrade as the conditional operator fails
  - From: Nithin Johnson
- Re: SELECT query fails after pg_upgrade as the conditional operator fails
  - From: Juan José Santamaría Flecha
- RE: SELECT query fails after pg_upgrade as the conditional operator fails
  - From: Nithin Johnson