Re: PG11 - Multiple Key Range Partition

Thank you guys for the quick response.

Which would be the simplest way to "import/apply" this fix locally for me?
Do I have to wait until the new version is released?

By the way, keep it up, awesome work!
Rares

On Wed, Jul 10, 2019 at 1:07 PM David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
wrote:

> On Wed, 10 Jul 2019 at 21:02, Amit Langote <amitlangote09(at)gmail(dot)com>
> wrote:
> >
> > On Wed, Jul 10, 2019 at 5:37 PM David Rowley
> > > Thanks for making the test case. It is a bug. There's a problem in
> > > match_clause_to_partition_key() where because
> > > match_boolean_partition_clause() returns false for the "NOT b"
> > > condition when comparing to the first partition key this causes the
> > > function to return PARTCLAUSE_UNSUPPORTED which causes the calling
> > > function to not bother trying to match that qual up to any other
> > > partition key.
> >
> > Oops, indeed a bug. Should've returned PARTCLAUSE_NOMATCH there.
>
> Here's a first draft fix for this, based on master.
>
> --
> David Rowley http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>