Postgres Pro
Downloads
Home   >   mailing lists

Re: bugfix: BUG #15477: Procedure call with named inout refcursorparameter - "invalid input syntax for type boolean" - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: bugfix: BUG #15477: Procedure call with named inout refcursorparameter - "invalid input syntax for type boolean"
Date
Msg-id CAFj8pRCF3pia7gScM0jh7vY9rEuqN7fbnUV+jymRTLEXZeRDNA@mail.gmail.com
Whole thread Raw
In response to Re: bugfix: BUG #15477: Procedure call with named inout refcursorparameter - "invalid input syntax for type boolean"  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: bugfix: BUG #15477: Procedure call with named inout refcursorparameter - "invalid input syntax for type boolean"
List pgsql-hackers
Tree view


čt 1. 11. 2018 v 13:10 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:


čt 1. 11. 2018 v 13:00 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
Hi

The processing of named parameters inside CALL statement is not correct.

It is my code :-/. I am sorry

Attached patch fix it.

This still doesn't fix INOUT variables with default value - so is not fully correct, but in this moment, it can show, where is a core of this issue.

This version disallow INOUT default variables from plpgsql

Probably correct solution is saving transformed arguments after expand_function_arguments and iterating over transformed argument list, not over
original argument list.




Regards

Pavel

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Commitfest 2018-11
Next
From: Stephen Frost
Date:
Subject: Re: Commitfest 2018-11