Cannot "Move Feature" in QGIS for PostGIS layers

Question

I cannot seem to Move Feature for PostGIS layers in QGIS 3 (2.99 43a9bc1) after I enabled editing as shown below.

Even though I can add features with the Add button, the Move Feature button is greyed out.

Does anyone know what might be the cause or how to fix it?

--EDIT--

Regarding the table, I do have the privileges as I am the owner of the db, and I just verified that I can create features in it. I also created a field called ogc_field because of prior issue with updating the table in question. Unable to update features in tables without FID: How to use gid field as the FID column with ogr/gdal python? .

ogc_fid | integer | not null default nextval('cfl.match_opl_prmatch_ex_pl62__p5_ogc_fid_seq'::regclass) | plain |

I don't know if this is sufficient for QGIS.

from my experience using the move feature will not work with a postgis table. save it as a geoJSON and it should work — ziggy, Commented Oct 4, 2017 at 17:51
@DPSSpatial ive tried it as a superuser and the tool was grayed out. but maybe you are correct — ziggy, Commented Oct 4, 2017 at 18:34
Primary Key is always a factor when editing PostGIS data in QGIS... @ziggy I always look for that first... — Inactivated Account, Commented Oct 4, 2017 at 21:17

JGH · Accepted Answer · 2017-10-04 17:25:34Z

7

Your user is lacking the UPDATE privilege on the layer.

PS: after granting it, you would need to re-open the project to see the changes.

answered Oct 4, 2017 at 17:25

JGH

43.1k3 gold badges46 silver badges93 bronze badges

Add a comment |

Inactivated Account · Accepted Answer · 2017-10-04 21:17:46Z

4

Does your dataset have a primary key assigned? Even if its just an arbitrary OBJECTID, you need to have that to do any editing in QGIS.

answered Oct 4, 2017 at 21:17

18.9k5 gold badges70 silver badges114 bronze badges

Add a comment |

2 Answers 2