Re: FATAL: operator class "xxxx" does not exist for access method "btree"

Поиск
Список
Период
Сортировка
От mao zhang
Тема Re: FATAL: operator class "xxxx" does not exist for access method "btree"
Дата
Msg-id CAHK7YHj3nRU8jqW0hboKnbE6ZSZ-iQMPv+m25OAXb1=GHaJ7AA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FATAL: operator class "xxxx" does not exist for access method "btree"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Support worker_spi to execute the function dynamically.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Support worker_spi to execute the function dynamically.