jian he <jian.universal...@gmail.com> writes: > On Wed, Apr 24, 2024 at 5:47 PM Yugo NAGATA <nag...@sraoss.co.jp> wrote: >> This message was introduced by 278cb434110 which was aiming to >> standardize the wording for similar errors. We can find the pattern >> "missing {support function | operator} %d(%u,%u) in opfamily %u" >> in several places.
> the error message > ` operator %d` > would translate to > ` operator 3` > but there is oid as 3 operator in the catalog. > that's my confusion. That number is the opclass' operator strategy number, not an OID (which is why it's formatted as %d not %u). See https://www.postgresql.org/docs/devel/xindex.html#XINDEX-STRATEGIES regards, tom lane