Re: [pgAdmin4][Patch]: RM #3354 Debugger does not start if functionhas input vars of type array - Mailing list pgadmin-hackers

From Dave Page
Subject Re: [pgAdmin4][Patch]: RM #3354 Debugger does not start if functionhas input vars of type array
Date
Msg-id CA+OCxozbjCef-riWz9OBxfR3VjNRiQ5NWWsO=2TM0k5acUEVUA@mail.gmail.com
Whole thread Raw
In response to [pgAdmin4][Patch]: RM #3354 Debugger does not start if function hasinput vars of type array  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Responses Re: [pgAdmin4][Patch]: RM #3354 Debugger does not start if functionhas input vars of type array  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-hackers
Hi

On Fri, Nov 16, 2018 at 6:53 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Hackers,

Attached is the patch to fix the RM #3354 "Debugger does not start if function has input vars of type array". Apart from that patch contains fix for the following:
  • Parameter values showing twice in case of array.
  • Allow null values in "InputIntegerArrayCell". 
Please review it.

Testing with a function which takes a oid[] as an argument, if I use an array of numbers it works, but if I enter NULL and a number I get:

ERROR: invalid input syntax for type oid: "NULL" LINE 3: 'NULL', '456']::oid[] ^ SQL state: 22P02 Character: 47 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Import/export servers
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Fix toggle breakpoints buttons in the debugger.Fixes