Postgres Pro
Downloads
Home   >   mailing lists

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

From Suresh Thelkar
Subject Re: SELECT query fails after pg_upgrade as the conditional operatorfails
Date
Msg-id 732DE4C9-E88F-4468-B49B-AE02A34270BC@asiapac.altair.com
Whole thread Raw
In response to Re: SELECT query fails after pg_upgrade as the conditional operator fails  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
List pgsql-admin
Tree view

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.santamaria@gmail.com>
Date: Sunday, 14 April 2019 at 3:48 PM
To: Nithin Johnson <nithin.johnson@altair.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>, Suresh Thelkar <suresh.thelkar@altair.com>, subhasis bhattacharya <subhasis.bhattacharya@altair.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

pgsql-admin by date:

Previous
From: Евгений Илюшин
Date:
Subject: Error when select global.service table
Next
From: Mahmoud Moharam
Date:
Subject: iscsi performance