From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Peter Geoghegan <pg@bowt.ie>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Teodor Sigaev <teodor@sigaev.ru>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Jaime Casanova <jaime.casanova@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Partitioned tables and covering indexes
Date: Wed, 11 Apr 2018 17:29:38 -0400
Message-ID: <352da91b-caeb-bbd9-cfe5-f477ad2628be@2ndquadrant.com> (raw)
In-Reply-To: <CAH2-Wzkdg_StJuH9MtiiYA=WyJDk_1S2ZVtSPQz73hkKgBz2sQ@mail.gmail.com>
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>
On 4/11/18 17:08, Peter Geoghegan wrote:
>> However, I don't see any point in defining collations here, because
>> INCLUDE attributes exist solely for index-only scans. So, index just
>> can return value of INCLUDE attribute "as is", no point to do something
>> with collation.
>>
>> So, I propose to disable collations for INCLUDE attributes.
> Hmm. I'm not sure that that's exactly the right thing to do. We seem
> to want to have case-insensitive collations in the future. The fact
> that you can spell out collation name in ON CONFLICT's unique index
> inference specification suggests this, for example. I think that a
> collation is theoretically allowed to affect the behavior of equality,
> even though so far we've never tried to make that work for any
> collatable datatype.
But in this case it doesn't even do equality comparison, it just returns
the value.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, pg@bowt.ie, a.korotkov@postgrespro.ru, alvherre@alvh.no-ip.org, teodor@sigaev.ru, Langote_Amit_f8@lab.ntt.co.jp, jaime.casanova@2ndquadrant.com
Subject: Re: Partitioned tables and covering indexes
In-Reply-To: <352da91b-caeb-bbd9-cfe5-f477ad2628be@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox