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

Commit error : Unable to commit changes for Dataset layer #106

Open image80 opened 2 years ago

image80 commented 2 years ago

Good morning, I work with the last pgmetadata plugin : 1.1.

I'm not able to save edits. When i add a new feature into Dataset, there is an error message saying :

"WARNING Commit errors: Unable to commit changes for Dataset layer"
ERROR: 1 feature(s) not added.
Data provider error:
               PostGIS error when adding feature: ERROR: Duplicate key value breaks unique constraint 'dataset_table_name_schema_name_key'
               DETAIL: The key "(table_name, schema_name)=(CigeoZH_Po_20220228, andra_naturel)" already exists.

If anyone could help me? Thanks a lot.

Gustry commented 2 years ago

The error is duplicated entry for table "CigeoZH_Po_20220228" and schema "andra_naturel". You should check in your dataset table for the other duplicated row. Only a single metadata sheet is possible per layer.