Guancheng Luo <prajnam...@gmail.com> writes: > On Mar 26, 2020, at 01:00, Tom Lane <t...@sss.pgh.pa.us> wrote: >> This would reject, for example, a hash index associated with a btree-based >> partition constraint, but I'm not sure we're losing anything much thereby.
> There is cases when a BTREE index associated with a HASH partition key, but I > think we should allow them, > as long as their equality operators consider the same value as equal. Ah, yeah, I see we already have regression test cases that require that. I pushed the patch with some cosmetic revisions. I left out the regression test case though; it seemed pretty expensive considering that the code is already being exercised by existing cases. Thanks for the report and patch! regards, tom lane