Re: CALL and named parameters

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