public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Christoph Moench-Tegeder <[email protected]>
Cc: Dominique Devienne <[email protected]>
Cc: Pavel Stehule <[email protected]>
Cc: [email protected]
Subject: Re: CALL and named parameters
Date: Thu, 07 Aug 2025 19:33:25 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
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>
<[email protected]>
Christoph Moench-Tegeder <[email protected]> writes:
> ## Dominique Devienne ([email protected]):
>> 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
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: CALL and named parameters
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox