Opened 16 years ago

Closed 16 years ago

Last modified 14 years ago

#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


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 leo.lami, 16 years ago

Platform Version: LinuxLinux and Windows

Linux and Windows platform

comment:2 by leo.lami, 16 years ago

Must Fix for Release: NoYes

comment:3 by mhugent, 16 years ago

Owner: changed from nobody to mhugent

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


comment:4 by mhugent, 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.

comment:5 by jef, 16 years ago

Resolution: fixed
Status: newclosed

fixed in r7642

comment:6 by (none), 14 years ago

Milestone: Version 0.9.1

Milestone Version 0.9.1 deleted

Note: See TracTickets for help on using tickets.