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
