2020-11-23T11:53:31 WARNING Key field 'id_liaison' for view/query not found.
2020-11-23T11:53:31 WARNING Keys for view/query undefined.
2020-11-23T11:53:31 WARNING PostgreSQL layer has no primary key.
2020-11-23T11:53:31 WARNING Erroneous query: SELECT * FROM "veloroutes"."poi_portion" LIMIT 1 returned 7 [ERROR: relation "veloroutes.poi_portion" does not exist
LINE 1: SELECT * FROM "veloroutes"."poi_portion" LIMIT 1
^
]
2020-11-23T11:53:31 WARNING Unable to access the "veloroutes"."poi_portion" relation.
The error message from the database was:
ERROR: relation "veloroutes.poi_portion" does not exist
LINE 1: SELECT * FROM "veloroutes"."poi_portion" LIMIT 1
^
.
SQL: SELECT * FROM "veloroutes"."poi_portion" LIMIT 1
2020-11-23T11:53:31 WARNING Erroneous query: SELECT * FROM (SELECT
id_poi,
id_local as "ID_LOCAL",
id_on3V AS "ID_ON3V",
(SELECT av.libelle FROM veloroutes.poi_acces_val AS av WHERE av.code = type) AS "TYPE",
description AS "DESCRIPT",
CASE
WHEN EXISTS (SELECT 1 FROM exports.poi_portion AS pp WHERE pp.id_poi = poi.id_poi)
THEN (SELECT etp.etape
FROM veloroutes.etape as etp
JOIN exports.poi_portion as pp ON pp.id_portion = etp.id_portion
WHERE pp.id_poi = poi.id_poi
)
ELSE NULL
END AS "ID_ETAPE",
geom
FROM veloroutes.poi_acces as poi
) AS "subQuery_0" LIMIT 1 returned 7 [ERROR: relation "exports.poi_portion" does not exist
LINE 8: WHEN EXISTS (SELECT 1 FROM exports.poi_portion AS pp WHER...
^
]
2020-11-23T11:53:31 WARNING Unable to execute the query.
The error message from the database was:
ERROR: relation "exports.poi_portion" does not exist
LINE 8: WHEN EXISTS (SELECT 1 FROM exports.poi_portion AS pp WHER...
^
.
SQL: SELECT * FROM (SELECT
id_poi,
id_local as "ID_LOCAL",
id_on3V AS "ID_ON3V",
(SELECT av.libelle FROM veloroutes.poi_acces_val AS av WHERE av.code = type) AS "TYPE",
description AS "DESCRIPT",
CASE
WHEN EXISTS (SELECT 1 FROM exports.poi_portion AS pp WHERE pp.id_poi = poi.id_poi)
THEN (SELECT etp.etape
FROM veloroutes.etape as etp
JOIN exports.poi_portion as pp ON pp.id_portion = etp.id_portion
WHERE pp.id_poi = poi.id_poi
)
ELSE NULL
END AS "ID_ETAPE",
geom
FROM veloroutes.poi_acces as poi
) AS "subQuery_0" LIMIT 1
2020-11-23T11:53:31 WARNING Erroneous query: SELECT count(distinct ("code"))=count(("code")) FROM (SELECT
id,
libelle AS "LIBELLE",
code AS "CODE"
FROM veloroutes.
etat_avancement_val) AS "subQuery_0" returned 7 [ERROR: column "code" does not exist
LINE 1: SELECT count(distinct ("code"))=count(("code")) FROM (SELECT
^
]
Some of them are criticals.
Some layers are skipped during the export because layers are invalid. It might be related.
From QGIS logs:
Some of them are criticals.
Some layers are skipped during the export because layers are invalid. It might be related.