Re: FATAL: operator class "xxxx" does not exist for access method "btree" - Mailing list pgsql-hackers

From mao zhang
Subject Re: FATAL: operator class "xxxx" does not exist for access method "btree"
Date
Msg-id CAHK7YHj3nRU8jqW0hboKnbE6ZSZ-iQMPv+m25OAXb1=GHaJ7AA@mail.gmail.com
Whole thread Raw
In response to Re: FATAL: operator class "xxxx" does not exist for access method "btree"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Fixed! 

Tom Lane <tgl@sss.pgh.pa.us> 于2023年7月19日周三 11:10写道:
mao zhang <mzhang2048@gmail.com> writes:
>     running bootstrap script ... 2023-07-19 09:40:47.083 CST [2808392] FATAL:
>  operator class "key_ops" does not exist for access method "btree"

I'm not sure what you find so mysterious about that error message.

>       Oid                                     global_key_id;
> ...
> DECLARE_UNIQUE_INDEX(pg_bm_client_global_keys_args_oid_index,8063,BmClientGlobalKeysArgsOidIndexId,on pg_bm_client_global_keys_args using btree(global_key_id key_ops));

If global_key_id is an OID, why aren't you declaring its index
with opclass oid_ops, rather than the quite nonexistent "key_ops"?

                        regards, tom lane

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Support worker_spi to execute the function dynamically.
Next
From: Michael Paquier
Date:
Subject: Re: Support worker_spi to execute the function dynamically.