Horton

Re: hash_array_extended() needs to pass down collation

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-11-04T11:51:40Z
Lists: pgsql-hackers 
On 2020-11-03 11:48, Michael Paquier wrote:
> On Mon, Nov 02, 2020 at 10:01:53AM -0500, Tom Lane wrote:
>> Peter Eisentraut <peter.eisentraut@enterprisedb.com> 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 this.
>>
>> LGTM
> 
> +1.

committed

Commits

  1. Enable hash partitioning of text arrays

  2. Collations with nondeterministic comparison