[QGIS-Developer] QGIS & field computer and unauthorized DB structure change (2nd attempt)
Hello everyone, unfortunately there was no feedback to my first request, so here is the 2nd attempt. I think the problem should affect many people, right? I have noticed the following: if I have read and write access (DML) to a PostgreSQL table, but no access to structure changes (DDL), then I can, for example, add new columns with the field calculator and fill them with results. Everything seems to run normally, I do not get a warning that I am not allowed to change the structure, the results generated in the field calculator are OK. After saving, all new columns including the data are gone. Can a corresponding preliminary check with warning be added here please? If a new column is explicitly added, a message appears whose content does not match the situation. "Could not add field 'Test' of type 'text'. Is the field name unique?“ A warning regarding missing authorizations for DB structure changes would be better. As far as I know, there is no QGIS ticket or change request(https://github.com/qgis/QGIS/issues) to improve the user guidance for these two cases. There are currently two relevant sections in the error messages(https://github.com/qgis/QGIS/blob/master/i18n/qgis_de.ts). Failed to add field '%1' of type '%2'. Is the field name unique? Could not add field '%1' of type '%2'. Is the field name unique? Failed to add field '%1' of type '%2'. Is the field name unique? Could not add field '%1' of type '%2'. Is the field name unique? Many thanks in advance. Mike Elstermann ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
[QGIS-Developer] QGIS & field computer and unauthorized DB structure change
Hello everyone, I have noticed the following: if I have read and write access (DML) to a PostgreSQL table, but no access to structure changes (DDL), then I can, for example, add new columns with the field calculator and fill them with results. Everything seems to run normally, I do not get a warning that I am not allowed to change the structure, the results generated in the field calculator are OK. After saving, all new columns including the data are gone. Can a corresponding preliminary check with warning be added here please? If a new column is explicitly added, a message appears whose content does not match the situation. "Could not add field 'Test' of type 'text'. Is the field name unique?“ A warning regarding missing authorizations for DB structure changes would be better. As far as I know, there is no QGIS ticket or change request(https://github.com/qgis/QGIS/issues) to improve the user guidance for these two cases. There are currently two relevant sections in the error messages(https://github.com/qgis/QGIS/blob/master/i18n/qgis_de.ts). Failed to add field '%1' of type '%2'. Is the field name unique? Could not add field '%1' of type '%2'. Is the field name unique? Failed to add field '%1' of type '%2'. Is the field name unique? Could not add field '%1' of type '%2'. Is the field name unique? Many thanks in advance. Mike Elstermann ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
[QGIS-Developer] Mac-Package for QGIS 3.34.0: Problem with GDAL/GEOS-Version
On QGIS for Mac, only GDAL version 3.3.2 and GEOS 3.9.1 are currently available in the latest QGIS 3.34.0. When can we expect the new GDAL/GEOS versions in the Mac-Package? The reason for my request is that GDAL drivers for newer geo formats (e.g. geoparquet) are missing and the "Multi Union" plugin does not work because it requires at least GEOS 3.10. Thanks in advance! Best regards, mikeE. ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer