Re: minor error message inconsistency in make_pathkey_from_sortinfo - Mailing list pgsql-hackers

jian he <jian.universality@gmail.com> writes:
> On Wed, Apr 24, 2024 at 5:47 PM Yugo NAGATA <nagata@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