Yep, I think Alexandre is correct. Change this to: create table bidule (id serial primary key, libelle text, geog geography(multipolygon, 4326)); or, given you already have the table: alter table bidule add constraint bidule_pk primary key (id);
You might find this link useful:https://www.cadlinecommunity.co.uk/hc/en-us/articles/360000579817-PostGIS-Why-can-I-not-edit-my-PostGIS-data-within-QGIS- Cheers On Monday, March 8, 2021, 1:58:12 PM GMT+13, Marc Millas <marc.mil...@mokadb.com> wrote: Hi, create table bidule (id serial, libelle text, geog geography(multipolygon, 4326)); as simple as possible :-) thanks for your help ! Marc MILLASSenior Architect+33607850334www.mokadb.com On Mon, Mar 8, 2021 at 1:25 AM Alexandre Neto <senhor.n...@gmail.com> wrote: Hello Marc, Can you share your table SQL definition? My gut feeling is that you might not have a unique identifier column. Alexandre NetoQGIS Supportwww.cooperative.net On Sun, Mar 7, 2021 at 9:51 PM Marc Millas <marc.mil...@mokadb.com> wrote: Hi,I may be missing something more than obvious, but ...QGIS 3.16 on win 10, postgres 12 with postgis 3.1 (same, machine (intel core i9, 64 GB ram, 6TB SSD))a postgis table with a column geography(multipolygon, 4326)-no pb to display this as a layer over whatever map (OSM standard as an exemple).-no pb in qgis to go to edition mode, and add a few new polygons, edit the table fields and save. fine.When I want to edit (ie. change..) one of the existing polygons, I:--ask to go to edit mode with right click on that postgis layer--select one of the existing polygons, (after choosing the select entity icon)--??? according to the doc, I should click on the edit node icon. Which is grayed.the qgis postgres user have all rights to write (proof by the inserts done) So.. there is something obvious somewhere, but I need some help to guess where :-)thanks for your help,regards, Marc MILLASSenior Architect+33607850334www.mokadb.com _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
