<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<pre style="text-wrap-mode: wrap; font-variant-ligatures: normal; orphans: 2; widows: 2; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Hello everyone,</pre>
<pre style="text-wrap-mode: wrap; font-variant-ligatures: normal; orphans: 2; widows: 2; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">unfortunately there was no feedback to my first request, so here is the 2nd attempt. I think the problem should affect many people, right?</pre>
<pre style="text-wrap-mode: wrap; font-variant-ligatures: normal; orphans: 2; widows: 2; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">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(<a href="https://github.com/qgis/QGIS/issues">https://github.com/qgis/QGIS/issues</a>) to improve the user guidance for these two cases.
There are currently two relevant sections in the error messages(<a href="https://github.com/qgis/QGIS/blob/master/i18n/qgis_de.ts">https://github.com/qgis/QGIS/blob/master/i18n/qgis_de.ts</a>).
<message>
<location filename="../src/app/qgsattributetabledialog.cpp" line="969"/>
<source>Failed to add field '%1' of type '%2'. Is the field name unique?</source>
<translation>Could not add field '%1' of type '%2'. Is the field name unique?</translation>
</message>
<message>
<location filename="../src/gui/vector/qgssourcefieldsproperties.cpp" line="286"/>
<source>Failed to add field '%1' of type '%2'. Is the field name unique?</source>
<translation>Could not add field '%1' of type '%2'. Is the field name unique?</translation>
</message>
Many thanks in advance.
Mike Elstermann</pre>
</body>
</html>