Bug report #763
Problem editing a postgis table
|Affected QGIS version:||Regression?:||No|
|Operating System:||Debian||Easy fix?:||No|
|Pull Request or Patch supplied:||Resolution:||fixed|
|Crashes QGIS or corrupts data:||Copied to github as #:||10822|
Trying to edit a a postgis-table. This seems to work as expected inside the GUI, but after deleting the layer, reload it, the datas do not appear changed.
The first time that I made the test, whn I click on 'Stop editing' QGIS say:
The PostgreSQL database returned: ERROR: syntax error at or near "="
LINE 1: UPDATE "public"."rm98_2007_lin" SET ='34455' WHERE "gid"=1
Durante la prova: UPDATE "public"."rm98_2007_lin" SET ='34455' WHERE "gid"=1
I think the problem is in the double quotes: "public"."rm98_2007_lin".
#3 Updated by Marco Hugentobler over 13 years ago
A part of this problem is fixed in . QGIS should now find the field name. However, it is still a problem to add new attribute fields to the table and insert/change values in these new fields in one go, because the names of the new fields are still unknown to the provider. This needs more work.