Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostGIS warnings lors de l'export des couches #95

Open
Gustry opened this issue Nov 23, 2020 · 0 comments
Open

PostGIS warnings lors de l'export des couches #95

Gustry opened this issue Nov 23, 2020 · 0 comments
Labels
bug Something isn't working

Comments

@Gustry
Copy link
Member

Gustry commented Nov 23, 2020

From QGIS logs:

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.

@Gustry Gustry added the bug Something isn't working label Nov 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant