Re: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Tom Lane
"Ian Bell" writes: > My function TestLtree() is being executed in the PGAdmin debugger. The > debugger requires I define the argument being passed, I set this to 'a.b.c' > and I have confirmed in the debugger that this is indeed what is passed into > the function. > I do not understand what

RE: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
SQL 10.3, compiled by Visual C++ build 1800, 64-bit under Windows 10. Thank, Ian -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 26 April, 2018 18:18 To: i...@ianbellsoftware.com Cc: 'Adrian Klaver' ; pgsql-general@lists.postgresql.org Subject: Re: PGAdmin4 d

Re: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Tom Lane
"Ian Bell" writes: > I just tried your suggestion and it generates the same error. For > verification, here is the function run in the debugger. I just realized that "syntax error at position N" is *not* the exact spelling you would get from a syntax error in PG's main parser, which I think is w

Re: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Adrian Klaver
On 04/26/2018 02:54 PM, Ian Bell wrote: Hello Adrian, I just tried your suggestion and it generates the same error.  For verification, here is the function run in the debugger. create or replace function TestLtreeV2( MyArg text ) returns void as $$ declare _testVar integer; begin S

RE: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
<mailto:i...@ianbellsoftware.com> ; pgsql-general@lists.postgresql.org <mailto:pgsql-general@lists.postgresql.org> Subject: Re: PGAdmin4 debugger - unable to call ltree functions On 04/26/2018 01:22 PM, Ian Bell wrote: > I have recently started working with the PGAdmin4 debugger and have &

Re: PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Adrian Klaver
On 04/26/2018 01:22 PM, Ian Bell wrote: I have recently started working with the PGAdmin4 debugger and have encountered a particular problem when testing my own functions that, in turn, call functions from the ltree module.   The sample code below successfully runs in  PSQL.  However, it fails

PGAdmin4 debugger - unable to call ltree functions

2018-04-26 Thread Ian Bell
I have recently started working with the PGAdmin4 debugger and have encountered a particular problem when testing my own functions that, in turn, call functions from the ltree module. The sample code below successfully runs in PSQL. However, it fails when run in the PGAdmin4 debugger. Specifi