Re: CUBE seems a bit confused about ORDER BY - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: CUBE seems a bit confused about ORDER BY
Date
Msg-id 3834058e-0ab9-be77-dccb-c57924adde0b@sigaev.ru
Whole thread Raw
In response to Re: CUBE seems a bit confused about ORDER BY  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: CUBE seems a bit confused about ORDER BY
List pgsql-hackers
>> Yes.  I bet only few users have built indexes over ~> operator if any.
>> Ask them to reindex in the release notes seems OK for me.
>>
> 
> Is there a good way to detect such cases? Either in pg_upgrade, so that
> we can print warnings, or at least manually (which would be suitable for
> release notes).

Hmm, suppose, fix should be backpatched (because now it's unusable) and 
pg_upgrade  should not do anything. Just add release note to 10.0 and 11.0

Oh, check expression is affected too, users will need to reinsert data.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Partition-wise aggregation/grouping
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager