From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Dominique Devienne <ddevienne@gmail.com>,
        Pavel Stehule <pavel.stehule@gmail.com>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: CALL and named parameters
In-reply-to: <CAKFQuwaGO-pmBVc2Vk9vwmbkhNpxHeZM77=oCtG+Duoc-G58cg@mail.gmail.com>
References: <CAFCRh-_iLoUtMAtyunw_-O6sgpWo04sOmB38MUVNpuQVSkL_0Q@mail.gmail.com> <CAFj8pRCyW4E5OnZDGvk_YnPqaS_PfK-VKJOKGndC-gtAtDOtBw@mail.gmail.com> <CAFCRh-9XkFS==OwSB6jgY84L5d4PkV_Y9MxLgk=NVx0Z8W3o_A@mail.gmail.com> <CAKFQuwaGO-pmBVc2Vk9vwmbkhNpxHeZM77=oCtG+Duoc-G58cg@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Thu, 07 Aug 2025 06:30:30 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1566946.1754576491.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 07 Aug 2025 10:21:31 -0400
Message-ID: <1566947.1754576491@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1566947.1754576491%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, August 7, 2025, Dominique Devienne <ddevienne@gmail.com> wr=
ote:
>> What's not nice is in the way it failed IMHO. I guess I persist it's
>> not a user friendly message :)

> Then write the error message you would have liked to see.

The message presumably was like

ERROR:  procedure ... does not exist
HINT:  No procedure matches the given name and argument types. You might n=
eed to add explicit type casts.

That HINT hasn't been updated since we added named arguments, but
"argument names don't match" is now also a possible failure reason.
The simplest possible change would be, say,

HINT:  No procedure matches the given name and argument names/types. You m=
ight need to add explicit type casts.

Not sure if that's good enough, but the matching rules are
complex enough that it'd be hard to be definitive about
the argument name being the problem.

			regards, tom lane