What is wrong with saving ltree?

S

Sergey Beloventsev2017-08-30 22:25:38

PostgreSQL

Sergey Beloventsev, 2017-08-30 22:25:38

actually here is the query

UPDATE "catalog" SET "tree_path"='119.202', "tree_url"='Moreprodukti.svegemorogenay-ryba' WHERE "id"=202

swears at it
"tree_url"='Moreprodukti.svegemorogenay-ryba'
swears at it

syntax error at position 27 The SQL being executed was

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Artem Klimenko, 2017-08-30
@Sergalas

the problem is in the "-" sign, it is an invalid character, it should either be removed or replaced with "_"