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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
