From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Moench-Tegeder <cmt@burggraben.net>
cc: Dominique Devienne <ddevienne@gmail.com>,
        Pavel Stehule <pavel.stehule@gmail.com>,
        pgsql-general@lists.postgresql.org
Subject: Re: CALL and named parameters
In-reply-to: <aJUzP5pwyObo6AeN@elch.exwg.net>
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>
Comments: In-reply-to Christoph Moench-Tegeder <cmt@burggraben.net>
	message dated "Fri, 08 Aug 2025 01:14:07 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1635991.1754609605.1@sss.pgh.pa.us>
Date: Thu, 07 Aug 2025 19:33:25 -0400
Message-ID: <1635992.1754609605@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1635992.1754609605%40sss.pgh.pa.us>
Precedence: bulk

Christoph Moench-Tegeder <cmt@burggraben.net> writes:
> ## Dominique Devienne (ddevienne@gmail.com):
>> dd_v185=> call "Epos-DBA".db_grant_connect_to(grantee_role => 'dd_joe');
>> ERROR:  procedure Epos-DBA.db_grant_connect_to(grantee_role =>
>> unknown) does not exist
>> LINE 1: call "Epos-DBA".db_grant_connect_to(grantee_role => '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.

			regards, tom lane