On Mon, Feb 26, 2018 at 10:59 PM, Amit Langote <langote_amit...@lab.ntt.co.jp> wrote: > You may say that partition bounds might have to be different too in this > case and hence partition-wise join won't occur anyway, but I'm wondering > if the mismatch of partcollation itself isn't enough to conclude that?
Yeah, you're right. I think that this is just a bug in partition-wise join, and that the partition scheme should just be using partcollation instead of parttypcoll, as in the attached. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
partition-scheme-collation.patch
Description: Binary data
