On Wed, May 10, 2017 at 10:13 PM, Robert Haas <robertmh...@gmail.com> wrote:
> On Wed, May 10, 2017 at 8:34 AM, Ashutosh Bapat
> <ashutosh.ba...@enterprisedb.com> wrote:
>> Hash partitioning will partition the data based on the hash value of the
>> partition key. Does that require collation? Should we throw an error/warning 
>> if
>> collation is specified in PARTITION BY clause?
> Collation is only relevant for ordering, not equality.  Since hash
> opclasses provide only equality, not ordering, it's not relevant here.
> I'm not sure whether we should error out if it's specified or just
> silently ignore it.  Maybe an ERROR is a good idea?  But not sure.
IMHO, we could simply have a WARNING, and ignore collation, thoughts?

Updated patches attached.


Attachment: 0001-Cleanup_v2.patch
Description: Binary data

Attachment: 0002-hash-partitioning_another_design-v5.patch
Description: Binary data

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to