Re: With commit 4e5fe9ad19, range partition missing handling for theNULL partition key - Mailing list pgsql-hackers

From Rushabh Lathia
Subject Re: With commit 4e5fe9ad19, range partition missing handling for theNULL partition key
Date
Msg-id CAGPqQf3xWKp4vdERhHGpVb81_BDZyXJYJVmQBMJTJenAhu3ouA@mail.gmail.com
Whole thread Raw
In response to Re: With commit 4e5fe9ad19, range partition missing handling for theNULL partition key  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: With commit 4e5fe9ad19, range partition missing handling for theNULL partition key  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers


On Wed, Nov 22, 2017 at 2:36 PM, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote:
On 2017/11/22 17:42, amul sul wrote:
> On Wed, Nov 22, 2017 at 11:38 AM, Amit Langote wrote:
>> On 2017/11/22 13:45, Rushabh Lathia wrote:
>>> Attaching patch to fix as well as regression test.
>>
>> Thanks for the patch.  About the code, how about do it like the attached
>> instead?
>>
>
> Looks good to me, even we can skip the following change in v2 patch:
>
> 19 @@ -2560,6 +2559,8 @@ get_partition_for_tuple(Relation relation,
> Datum *values, bool *isnull)
>  20                      */
>  21                     part_index =
> partdesc->boundinfo->indexes[bound_offset + 1];
>  22                 }
>  23 +               else
>  24 +                   part_index = partdesc->boundinfo->default_index;
>  25             }
>  26             break;
>  27
>
> default_index will get assign by following code in get_partition_for_tuple() :
>
>    /*
>      * part_index < 0 means we failed to find a partition of this parent.
>      * Use the default partition, if there is one.
>      */
>     if (part_index < 0)
>         part_index = partdesc->boundinfo->default_index;

Good point.  Updated patch attached.

Thanks Amit.

Patch looks good to me.


--
Rushabh Lathia

pgsql-hackers by date:

Previous
From: Rui Hai Jiang
Date:
Subject: How is the PostgreSQL debuginfo file generated
Next
From: "REIX, Tony"
Date:
Subject: PostgreSLQ v10.1 and xlC compiler on AIX