Postgres Pro
Downloads
Home   >   mailing lists

Re: no partition pruning when partitioning using array type - Mailing list pgsql-hackers

From Robert Haas
Subject Re: no partition pruning when partitioning using array type
Date
Msg-id CA+TgmoaH4aEA-0D8RZsthJuTNg3hDCAJAqWRzEuGfQgUQeJvFw@mail.gmail.com
Whole thread Raw
In response to Re: no partition pruning when partitioning using array type  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: no partition pruning when partitioning using array type
List pgsql-hackers
Tree view 
On Thu, Feb 1, 2018 at 4:42 AM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
>> I hope someone else chimes in as well. :)
>
> Bug #15042 [1] seems to be caused by this same problem.  There, a
> RelabelType node is being slapped (by the partitioning code) on a Var node
> of a partition key on enum.
>
> Attached updated patch.

Can I get anyone else to weigh in on whether this is likely to be
safe?  Paging people who understand constraint exclusion...

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Mark Rofail
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] MERGE SQL Statement for PG11