Re: BUG #17158: Distinct ROW fails with Postgres 14

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>, sait(dot)nisanci(at)microsoft(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17158: Distinct ROW fails with Postgres 14
Date: 2021-08-24 21:25:09
Message-ID: bc0ec85a-68cf-1b99-e80c-ee0c55b936db@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 24.08.21 11:55, David Rowley wrote:
> If it's going to be a problem detecting the lack of hashability during
> planning then maybe we can just add a hash opclass for BIT to fix this
> particular case.

The following types have btree opclasses but not hash opclasses:

money
bit
bit varying
tsvector
tsquery

Also among contrib:

cube
ltree
seg

We could fix the first three relatively easily (although money is used
in test cases as not having a hash opclass). Not sure what to do about
the rest.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-08-24 22:16:11 Re: BUG #17158: Distinct ROW fails with Postgres 14
Previous Message Tom Lane 2021-08-24 15:05:38 Re: BUG #17158: Distinct ROW fails with Postgres 14