pgsql: For partitionwise join, match on partcollation,not parttypcoll. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: For partitionwise join, match on partcollation,not parttypcoll.
Date
Msg-id E1er5Qh-000684-7Q@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
For partitionwise join, match on partcollation, not parttypcoll.

The previous code considered two tables to have the partition scheme
if the underlying columns had the same collation, but what we
actually need to compare is not the collations associated with the
column but the collation used for partitioning.  Fix that.

Robert Haas and Amit Langote

Discussion: http://postgr.es/m/0f95f924-0efa-4cf5-eb5f-9a3d1bc3c33d@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2af28e603319224e87fd35ab62f36ef6de45eaac

Modified Files
--------------
src/backend/optimizer/util/plancat.c | 6 +++---
src/include/nodes/relation.h         | 2 +-
2 files changed, 4 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Document LWTRANCHE_PARALLEL_HASH_JOIN.
Next
From: Catalin Iacob
Date:
Subject: Re: pgsql: Un-break parallel pg_upgrade.