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