Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: FATAL: operator class "xxxx" does not exist for access method "btree"
Date
Msg-id 134517.1689736222@sss.pgh.pa.us
Whole thread Raw
In response to FATAL: operator class "xxxx" does not exist for access method "btree"  (mao zhang <mzhang2048@gmail.com>)
Responses Re: FATAL: operator class "xxxx" does not exist for access method "btree"
List pgsql-hackers
Tree view 
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_argsusing 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: Peter Smith
Date:
Subject: Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication
Next
From: Michael Paquier
Date:
Subject: Re: Generating code for query jumbling through gen_node_support.pl