Re: PGAdmin4 debugger - unable to call ltree functions

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: PGAdmin4 debugger - unable to call ltree functions
Дата
Msg-id
6461.1524781094@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
RE: PGAdmin4 debugger - unable to call ltree functions "Ian Bell" <ib@ianbellsoftware.com>
Re: PGAdmin4 debugger - unable to call ltree functions Tom Lane <tgl@sss.pgh.pa.us>
RE: PGAdmin4 debugger - unable to call ltree functions "Ian Bell" <ib@ianbellsoftware.com>
Re: PGAdmin4 debugger - unable to call ltree functions Tom Lane <tgl@sss.pgh.pa.us>
Re: PGAdmin4 debugger - unable to call ltree functions Adrian Klaver <adrian.klaver@aklaver.com>
"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 what we were all assuming this'd trace down to somehow.

What it is is the (very poorly chosen) message you get if either
ltree_in() or lquery_in() doesn't like what it's been handed.
So basically, the problem here is that TestLtree() is being called
with a string that isn't a valid ltree representation.  You haven't
shown us what you are doing on that end, but for example I can
duplicate the error message with

# select text2ltree(' ');
ERROR:  syntax error at position 0

			regards, tom lane

В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Ian Bell
Дата:
FAQ