[Qgis-user] noobs -- question

[Brent Wood]

 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.millas at 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.neto at 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.millas at 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 at 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 at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210308/1ac73927/attachment.html>