From: Tom Lane <tgl@sss.pgh.pa.us>
To: jian he <jian.universality@gmail.com>
cc: Yugo NAGATA <nagata@sraoss.co.jp>,
        PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: minor error message inconsistency in make_pathkey_from_sortinfo
In-reply-to: <CACJufxGc3Ewc1MKm6qRpYe=kfHK_zbZ2OWVUsopbQSOHkpTgQA@mail.gmail.com>
References: <CACJufxGNJqR79WEwBRw9g2DB-6WhNcJs1uuG7KnTGA5ouM6eug@mail.gmail.com> <20240424184736.d16803a87d6c8a22088e0a2b@sraoss.co.jp> <CACJufxGc3Ewc1MKm6qRpYe=kfHK_zbZ2OWVUsopbQSOHkpTgQA@mail.gmail.com>
Comments: In-reply-to jian he <jian.universality@gmail.com>
	message dated "Thu, 25 Apr 2024 22:52:14 +0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3936412.1714057666.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Thu, 25 Apr 2024 11:07:46 -0400
Message-ID: <3936413.1714057666@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3936413.1714057666%40sss.pgh.pa.us>
Precedence: bulk

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