From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | ib(at)ianbellsoftware(dot)com |
Cc: | "'pgsql-novice'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: PGAdmin4 debugger - unable to call ltree functions |
Date: | 2018-04-26 18:59:23 |
Message-ID: | 24560.1524769163@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Ian Bell" <ib(at)ianbellsoftware(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Watkins | 2018-04-30 13:19:49 | Best practices guide for security |
Previous Message | Ian Bell | 2018-04-26 18:25:05 | PGAdmin4 debugger - unable to call ltree functions |