[QGIS-Developer] QGIS & field computer and unauthorized DB structure change (2nd attempt)

2024-03-18 Thread Elstermann, Mike via QGIS-Developer
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

2024-03-04 Thread Elstermann, Mike via QGIS-Developer
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

2023-11-15 Thread Elstermann, Mike via QGIS-Developer
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