Re: missing support of named convention for procedures

2018-03-20 17:31 GMT+01:00 Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com>:

> On 3/16/18 06:29, Pavel Stehule wrote:
> > attached patch fixes it
>
> The fix doesn't seem to work for LANGUAGE SQL procedures. For example:
>
> CREATE PROCEDURE ptest5(a int, b int DEFAULT 0)
> LANGUAGE SQL
> AS $$
> INSERT INTO cp_test VALUES (a, 'foo');
> INSERT INTO cp_test VALUES (b, 'bar');
> $$;
> CALL ptest5(a => 1, b => 2); -- ok
> CALL ptest5(b => 3, a => 4); -- ok
> CALL ptest5(5);
> ERROR: no value found for parameter 2
> CONTEXT: SQL function "ptest5" statement 2
> CALL ptest5(a => 6);
> ERROR: no value found for parameter 2
> CONTEXT: SQL function "ptest5" statement 2
>
> I'm not quite sure why this behaves differently from plpgsql. Needs
> more digging.
>

Do you working on this issue? Maybe tomorrow I'll have a time to look there.

Regards

Pavel

>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>