When running "restore" command and DB is PostgreSQL, restore fails with "ERROR: recursive query "tree" column [...] has type varchar(200) in non-recursive term but type character varying overall":
docker compose --env-file env.docker-compose run backend restore /backup/backup_04_02_2023-08_30_51.tar.gz
In order to fix the problem, SQL column needs to be casted to correct type. Note the ANSI SQL compatible syntax (x::type, is PostgreSQL specific syntax, while CAST(x as type) is ANSI SQL).
ciur
commented
1 year ago
Backend version: 2.1.5
When running "restore" command and DB is PostgreSQL, restore fails with "ERROR: recursive query "tree" column [...] has type varchar(200) in non-recursive term but type character varying overall":
In order to fix the problem, SQL column needs to be casted to correct type. Note the ANSI SQL compatible syntax (x::type, is PostgreSQL specific syntax, while CAST(x as type) is ANSI SQL).