Subject: Re: Partitioned tables and covering indexes
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
 Peter Geoghegan <pg@bowt.ie>
Cc: Alexander Korotkov <a.korotkov@postgrespro.ru>,
 Alvaro Herrera <alvherre@alvh.no-ip.org>,
 Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>,
 Jaime Casanova <jaime.casanova@2ndquadrant.com>,
 Pg Hackers <pgsql-hackers@postgresql.org>
References: <13123421-1d52-d0e4-c95c-6d69011e0595@sigaev.ru>
 <20180411194753.vhnwqss2hgqtao6v@alvherre.pgsql>
 <CAPpHfds2etOsc-YSu+TKn05099wJrZPDg8yMhE460X3O6Zpaig@mail.gmail.com>
 <CAH2-Wzkdg_StJuH9MtiiYA=WyJDk_1S2ZVtSPQz73hkKgBz2sQ@mail.gmail.com>
 <352da91b-caeb-bbd9-cfe5-f477ad2628be@2ndquadrant.com>
 <CAH2-Wzm0qH6BYaYGLFQB+Nz+O+g=k1Goe-ucdC2+8KhHG2KPfQ@mail.gmail.com>
 <641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com>
From: Teodor Sigaev <teodor@sigaev.ru>
Message-ID: <07465162-72d9-e192-bedb-6e37bca50b56@sigaev.ru>
Date: Thu, 12 Apr 2018 01:14:54 +0300
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101
 Firefox/52.0 SeaMonkey/2.49.2
MIME-Version: 1.0
In-Reply-To: <641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk

>> That's the idea that I tried to express. The point is that we need to
>> tell the user that there is no need to worry about it, rather than
>> that they're wrong to ask about it. Though we should probably actually
>> just throw an error.
> 
> Or maybe it should be the collation of the underlying table columns.
> Otherwise the collation returned by an index-only scan would be
> different from a table scan, no?
+1, dangerous
-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru
                                       WWW: http://www.sigaev.ru/