Re: [HACKERS] fix hard-coded index in make_partition_op_expr - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [HACKERS] fix hard-coded index in make_partition_op_expr
Date
Msg-id 12137aa5-0b5b-2084-4c9b-bcd670cf23c2@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] fix hard-coded index in make_partition_op_expr  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2017/05/18 3:43, Robert Haas wrote:
> On Wed, May 17, 2017 at 5:38 AM, Jeevan Ladhe
> <jeevan.ladhe@enterprisedb.com> wrote:
>> While browsing through the partitioning code, I noticed that a recent commit
>> f8bffe9e6d700fd34759a92e47930ce9ba7dcbd5, which fixes multi-column range
>> partitioning constraints, introduced a function make_partition_op_expr, that
>> takes keynum as a input parameter to identify the index of the partition
>> key.
>> In case of range partition we can have multiple partition keys but for list
>> partition we have only one. Considering that, I think following code does
>> not
>> cause any side-effect logically(and may be a oversight while moving the code
>> from function get_qual_for_list to this function):
>>
>> saopexpr->inputcollid = key->partcollation[0];
>> saopexpr->args = list_make2(arg1, arg2);
>>
>> But as we have keynum now, should we be using it to index
>> key->partcollation,
>> instead of a hard coded '0'.
> 
> Agreed.  Committed your patch.

Me too, thanks both.

Regards,
Amit




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] [Proposal] Allow users to specify multiple tables inVACUUM commands
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Race conditions with WAL sender PID lookups