Changes saved toward a Postgis table?

[image80]

Hello. It was simply to know if it was possible to save modifications toward a postgis table? (Postgresql Postgis serveur). Thanks.

[gacarrillor]

Hello. It was simply to know if it was possible to save modifications toward a postgis table? (Postgresql Postgis serveur).

If you have been granted write access, yes.

If you find any trouble don't hesitate to let us know.

Regards

[brusspi]

Hi,

I am testing your plugin to integrate it into our workflow. Appending works fine. But when choosing update, then it gives an error, saying that the target layer does not support updating. But that's not true. See images with more info.

Table settings:

[gacarrillor]

Hi, could you let me know what is the result of running the following Python code in the QGIS Python console?

(Before running it, make sure you have your target PostgreSQL layer selected in the "Layers panel")

caps = iface.activeLayer().dataProvider().capabilities()
bool(caps & QgsVectorDataProvider.ChangeAttributeValues)
bool(caps & QgsVectorDataProvider.ChangeGeometries)

You should get 2 boolean values.

[brusspi]

this is the result

caps = iface.activeLayer().dataProvider().capabilities() bool(caps & QgsVectorDataProvider.ChangeAttributeValues) True bool(caps & QgsVectorDataProvider.ChangeGeometries) False

[gacarrillor]

Great, that's what I was expecting.

Could you test the development version I'm attaching as ZIP and let me know if it fixes the issue you're reporting?

AppendFeaturesToLayer.zip

[brusspi]

Yes, now it works as expected. Great!

[gacarrillor]

Nice, we'll release soon a new public version with this fix included. Closing now as fixed.