Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: stepaunov@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2018-11-01T08:04:23Z
Lists: pgsql-bugs
> It is strange bug. When you use syntax =>, ":=" is obsolete (but still
> supported), then all is working
>
> postgres=# do $$
> declare
>   v_ResultSet refcursor;
>   v_cnt       integer;
> begin
>   call p1(v_cnt=>v_cnt, v_ResultSet => v_ResultSet);
>   raise notice '%', v_ResultSet;
> end;$$
> ;
> NOTICE:  <unnamed portal 4>
> DO
>
> looks so somewhere only new syntax is recognized and supported.
>

no, the behave is random. Looks on uninitialized variable

first call in session fails, seconds are ok


> Regards
>
> Pavel
>
>

Commits

  1. Fix bugs in plpgsql's handling of CALL argument lists.