operator class "xxx" does not exist for access method "yyy"

From: Tianyi Gao <gtydoit(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: operator class "xxx" does not exist for access method "yyy"
Date: 2023-03-21 12:51:14
Message-ID: CANZS+G_OpRDKNop+hsTCNBOq9C8bERyNPtE1gCsJm8kCt=1dDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello, I encountered some errors while using PostgreSQL. It seems that the
information in the pg_opclass cannot be found by syscache. Can you please
let me know if this is a bug and whether this syntax will be supported in
the future?

error:

*postgres=# CREATE TEMP TABLE issue(c0 FLOAT , c1 money NULL) PARTITION BY
HASH((issue.c0)cdbhash_float8_ops);ERROR: operator class
"cdbhash_float8_ops" does not exist for access method "hash"*

version:

*
version--------------------------------------------------------------------------------------------------------
PostgreSQL
16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit(1 row)*

Regards,
Tianyi Gao

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2023-03-21 13:00:00 Re: BUG #17858: ExecEvalArrayExpr() leaves uninitialised memory for multidim array with nulls
Previous Message Richard Guo 2023-03-21 11:52:58 Re: BUG #17858: ExecEvalArrayExpr() leaves uninitialised memory for multidim array with nulls