#763 closed bug (fixed)
Problem editing a postgis table
| Reported by: | leo.lami | Owned by: | mhugent |
|---|---|---|---|
| Priority: | major: does not work as expected | Milestone: | |
| Component: | Digitising | Version: | Trunk |
| Keywords: | Cc: | ||
| Must Fix for Release: | Yes | Platform: | Debian |
| Platform Version: | Linux and Windows | Awaiting user input: | no |
Description
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".
Change History (6)
comment:1 by , 16 years ago
| Platform Version: | Linux → Linux and Windows |
|---|
comment:2 by , 16 years ago
| Must Fix for Release: | No → Yes |
|---|
comment:3 by , 16 years ago
| Owner: | changed from to |
|---|
The problem is not the double quote. For some reason, qgis does not find the proper fieldname.
UPDATE "public"."rm98_2007_lin" SET ='34455' WHERE "gid"=1
should be:
UPDATE "public"."rm98_2007_lin" SET <fieldname>='34455' WHERE "gid"=1
Marco
comment:4 by , 16 years ago
A part of this problem is fixed in r7181. 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.
Linux and Windows platform