Re: hash_array_extended() needs to pass down collation

2020-11-04 Thread Peter Eisentraut
On 2020-11-03 11:48, Michael Paquier wrote: On Mon, Nov 02, 2020 at 10:01:53AM -0500, Tom Lane wrote: Peter Eisentraut writes: I noticed that hash_array_extended() does not pass down the collation to the element's collation function, unlike hash_array(). As a consequence, hash partitioning us

Re: hash_array_extended() needs to pass down collation

2020-11-03 Thread Michael Paquier
On Mon, Nov 02, 2020 at 10:01:53AM -0500, Tom Lane wrote: > Peter Eisentraut writes: >> I noticed that hash_array_extended() does not pass down the collation to >> the element's collation function, unlike hash_array(). As a >> consequence, hash partitioning using text arrays as partition key fa

Re: hash_array_extended() needs to pass down collation

2020-11-02 Thread Tom Lane
Peter Eisentraut writes: > I noticed that hash_array_extended() does not pass down the collation to > the element's collation function, unlike hash_array(). As a > consequence, hash partitioning using text arrays as partition key fails. > The attached patch fixes this. I propose to backpatch

Re: hash_array_extended() needs to pass down collation

2020-11-02 Thread Heikki Linnakangas
On 02/11/2020 09:40, Peter Eisentraut wrote: I noticed that hash_array_extended() does not pass down the collation to the element's collation function, unlike hash_array(). As a consequence, hash partitioning using text arrays as partition key fails. The attached patch fixes this. I propose to

hash_array_extended() needs to pass down collation

2020-11-02 Thread Peter Eisentraut
I noticed that hash_array_extended() does not pass down the collation to the element's collation function, unlike hash_array(). As a consequence, hash partitioning using text arrays as partition key fails. The attached patch fixes this. I propose to backpatch this. From 171c58bc37c211cab11f6b