2018-03-20 17:31 GMT+01:00 Peter Eisentraut < peter.eisentr...@2ndquadrant.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 >
