MIME-Version: 1.0
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>
 <aJUzP5pwyObo6AeN@elch.exwg.net> <1635992.1754609605@sss.pgh.pa.us>
In-Reply-To: <1635992.1754609605@sss.pgh.pa.us>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Fri, 8 Aug 2025 10:18:28 +0200
Message-ID: <CAFCRh--VmO20xaEoir9adHWGzG1v03syMiC4j0bYpwewjzE=cw@mail.gmail.com>
Subject: Re: CALL and named parameters
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Christoph Moench-Tegeder <cmt@burggraben.net>, Pavel Stehule <pavel.stehule@gmail.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--VmO20xaEoir9adHWGzG1v03syMiC4j0bYpwewjzE%3Dcw%40mail.gmail.com>
Precedence: bulk

On Fri, Aug 8, 2025 at 1:33=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Christoph Moench-Tegeder <cmt@burggraben.net> writes:
> > ## Dominique Devienne (ddevienne@gmail.com):
> >> dd_v185=3D> call "Epos-DBA".db_grant_connect_to(grantee_role =3D> 'dd_=
joe');
> >> ERROR:  procedure Epos-DBA.db_grant_connect_to(grantee_role =3D>
> >> unknown) does not exist
> >> LINE 1: call "Epos-DBA".db_grant_connect_to(grantee_role =3D> 'dd_joe'=
...
>
> > There's the problem: "unknown" type - consider that string there as
> > "too flexible", it can be coerced into too many types, so the error
> > says "unknown".
>
> No, the issue is that the procedure's named parameter is not named
> "grantee_role" but something else.  We'd have coerced the unknown
> parameter just fine, except that we never considered this procedure
> as a valid match at all.

That. And it failed just the same with a ::name cast, so no "unknown"
type there.
And in all of that, there's a single "Epos-DBA".db_grant_connect_to(...).
So it's not like the "candidates" are a large set. --DD