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

From: mao zhang <mzhang2048(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-20 04:25:47
Message-ID: CAHK7YHj3nRU8jqW0hboKnbE6ZSZ-iQMPv+m25OAXb1=GHaJ7AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fixed!

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 于2023年7月19日周三 11:10写道:

> 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-07-20 04:39:36 Re: Support worker_spi to execute the function dynamically.
Previous Message Bharath Rupireddy 2023-07-20 04:13:37 Re: Support worker_spi to execute the function dynamically.