George, thanks for your advice. After testing on a brand new table, I've figured out that this problem appears only with tables, that don’t have a primary key constraint in the db. When I add a primary key, my edits get committed to the base as expected. However, I’ve noticed that “Add PostGIS Table” dialog doesn’t show this table has a primary key (the "Primary key" column is empty). But when a table is added to the map, it has a key=“gid” option in "Layer source” field in “Properties" - “General" window.
Can anyone confirm the same issue is only when editing a table without primary key? > On 26 Jan 2015, at 05:15, George Silva <georger.si...@gmail.com> wrote: > > Weird. I'll try to reproduce. > > Doesnt seem like something that would slip by. > > Can you test again on a brand new table without any triggers or postgresql > magic behind? > > Em 25/01/2015 23:15, "Mofo Yoda" <mofoy...@gmail.com > <mailto:mofoy...@gmail.com>> escreveu: > Hi list, > > I have a non-spatial postgres table in my QGIS project which I want to edit > in attribute table window. When I open it, first time when I change any > attribute value and hit "Save Edits” button, the data is updated in the DB > and updated in QGIS attribute table window. But when I try to edit an > attribute of the same record the second time, when I hit save nothing is > updated in the db. But the attribute table shows new values. Stopping and > starting new editing session doesn’t help. The only thing that helps is > closing the attribute table window and reopening it again. Then I can edit > the value once again, but only one time. > PostGIS log window in QGIS is clean, I get no errors when hitting “Save > Edits”. I’m on version 2.6.0. > Does anyone have the same bug? > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org> > http://lists.osgeo.org/mailman/listinfo/qgis-user > <http://lists.osgeo.org/mailman/listinfo/qgis-user>
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
