public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dominique Devienne <[email protected]>
To: Tom Lane <[email protected]>
Cc: Christoph Moench-Tegeder <[email protected]>
Cc: Pavel Stehule <[email protected]>
Cc: [email protected]
Subject: Re: CALL and named parameters
Date: Fri, 8 Aug 2025 10:18:28 +0200
Message-ID: <CAFCRh--VmO20xaEoir9adHWGzG1v03syMiC4j0bYpwewjzE=cw@mail.gmail.com> (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]>
<[email protected]>
On Fri, Aug 8, 2025 at 1:33 AM Tom Lane <[email protected]> wrote:
> 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.
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
view thread (10+ messages)
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: <CAFCRh--VmO20xaEoir9adHWGzG1v03syMiC4j0bYpwewjzE=cw@mail.gmail.com>
* 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