search

3liz / qgis-pgmetadata-plugin

QGIS Plugin to manage some metadata from PostgreSQL layer
GNU General Public License v2.0
12 stars 10 forks source link

Error detecting layers not based an postgresql table #108

Open Gustry opened 2 years ago

Gustry commented 2 years ago

QgsDataSourceUri can be based on a table like : 

(SELECT * FROM foo) AS t

PgMetadata is failing loading the metadatasheet on these layers : 

2022-03-29T12:36:50     CRITICAL    Error when querying the database : Erreur SQL : SELECT pgmetadata.get_dataset_item_html_content('france', '(SELECT * FROM france.parcelles WHERE id_parcelles IN ('11203000AL0122','11203000AL0123','11203000AL0124'))', 'fr'); renvoyé 0 [ERROR: syntax error at or near "11203000"
             LINE 1: ...T * FROM france.parcelles WHERE id_parcelles IN ('11203000AL...