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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mao zhang <mzhang2048(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: FATAL: operator class "xxxx" does not exist for access method "btree"
Date: 2023-07-19 03:10:22
Message-ID: 134517.1689736222@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mao zhang <mzhang2048(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-07-19 03:30:57 Re: Generating code for query jumbling through gen_node_support.pl
Previous Message Peter Smith 2023-07-19 03:07:58 Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication