pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: 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 18:11:36 -0400
Message-ID: <641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com> (raw)
In-Reply-To: <CAH2-Wzm0qH6BYaYGLFQB+Nz+O+g=k1Goe-ucdC2+8KhHG2KPfQ@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>
	<352da91b-caeb-bbd9-cfe5-f477ad2628be@2ndquadrant.com>
	<CAH2-Wzm0qH6BYaYGLFQB+Nz+O+g=k1Goe-ucdC2+8KhHG2KPfQ@mail.gmail.com>

On 4/11/18 17:38, Peter Geoghegan wrote:
> On Wed, Apr 11, 2018 at 2:29 PM, Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com> wrote:
>> But in this case it doesn't even do equality comparison, it just returns
>> the value.
> 
> 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?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




view thread (22+ messages)  latest in thread

Message-ID: <641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com>
Permalink:  ../641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com/
Also on:    postgresql.org/message-id/641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com

 · 

reply
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: <641a91aa-19ef-e092-dd4c-2554487169fc@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