Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "Ghiurea, Isabella" <Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Date: 2019-10-22 16:27:52
Message-ID: CAMkU=1zJS6kwYcF92f=e2uE8Fwmu1pyj=5i_nfzQD9ZT991kUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Oct 22, 2019 at 12:08 PM Ghiurea, Isabella <
Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca> wrote:

> Hi Jeff,
>
> Thank you for suggestion, yes we tested without Pgsphere index ( dropped
> the index) in PGSQL 10.9 , run same SQL and got the expected result which
> is same as the one in PG 9.5 but different f when using the PG sphere in
> 10.9( which returned null rows),
>

If you recreate the index, is it still broken or does it work properly?

Cheers,

Jeff

>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Karl Denninger 2019-10-23 02:48:58 Upgrade failure attempting to go to 12.0
Previous Message Ghiurea, Isabella 2019-10-22 16:07:58 Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.