Re: PGAdmin4 debugger - unable to call ltree functions - Mailing list pgsql-novice

"Ian Bell" <ib@ianbellsoftware.com> writes:
> 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.   Specifically, the debugger generates the following error message
> when it executes the first call to 'text2ltree':

> ERROR: syntax error at position 0 
> CONTEXT: SQL statement "SELECT exists ( select 1 from TableLtree where
> MyPath = text2ltree( MyArg ) )" 
> PL/pgSQL function testltree(text) line 5 at IF

Hm, I have no idea what's going on there, but maybe you could get some
insight by looking at what shows up in the postmaster log file --- that
might be more verbose than what PGAdmin is showing you.

Also, you could likely get more help on the pgadmin mailing list than
here.

            regards, tom lane