<div dir="ltr">Fine !<div>it does work.</div><div>thanks for your help,</div><div><br></div><div>regards</div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr">Marc MILLAS<div>Senior Architect</div><div>+33607850334</div><div><a href="http://www.mokadb.com" target="_blank">www.mokadb.com</a></div><div><br></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Mar 8, 2021 at 2:09 AM Brent Wood <<a href="mailto:pcreso@yahoo.com">pcreso@yahoo.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:verdana,helvetica,sans-serif;font-size:16px"><div></div>
<div dir="ltr">Yep, I think Alexandre is correct.<br></div><div dir="ltr"><br></div><div dir="ltr">Change this to:</div><div dir="ltr"><br></div><div dir="ltr"><i><span>create table bidule (id serial primary key, libelle text, geog geography(multipolygon, 4326));</span></i></div><div dir="ltr"><span><br></span></div><div dir="ltr"><span>or, given you already have the table:</span></div><div dir="ltr"><span><br></span></div><div dir="ltr"><i><span>alter table bidule</span></i></div><div dir="ltr"><i><span> add constraint bidule_pk primary key (id);<br></span></i></div><div dir="ltr"><span><br></span></div><div dir="ltr"><span></span><div><div><br></div></div><div dir="ltr">You might find this link useful:</div><div dir="ltr"><a href="https://www.cadlinecommunity.co.uk/hc/en-us/articles/360000579817-PostGIS-Why-can-I-not-edit-my-PostGIS-data-within-QGIS-" rel="nofollow" target="_blank">https://www.cadlinecommunity.co.uk/hc/en-us/articles/360000579817-PostGIS-Why-can-I-not-edit-my-PostGIS-data-within-QGIS-</a></div><div><br></div><div dir="ltr">Cheers<br></div><div><br></div></div><div><br></div>
</div><div id="gmail-m_-5428697268660285684ydp67d598bdyahoo_quoted_6064784726">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Monday, March 8, 2021, 1:58:12 PM GMT+13, Marc Millas <<a href="mailto:marc.millas@mokadb.com" target="_blank">marc.millas@mokadb.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="gmail-m_-5428697268660285684ydp67d598bdyiv2836195895"><div><div dir="ltr">Hi,<div><br clear="none"></div><div>create table bidule (id serial, libelle text, geog geography(multipolygon, 4326));</div><div><br clear="none"></div><div><br clear="none"></div><div>as simple as possible :-)</div><div><br clear="none"></div><div>thanks for your help !</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr">Marc MILLAS<div>Senior Architect</div><div>+33607850334</div><div><a shape="rect" href="http://www.mokadb.com" rel="nofollow" target="_blank">www.mokadb.com</a></div><div><br clear="none"></div></div></div></div></div></div><br clear="none"></div></div><br clear="none"><div id="gmail-m_-5428697268660285684ydp67d598bdyiv2836195895yqt82169"><div><div dir="ltr">On Mon, Mar 8, 2021 at 1:25 AM Alexandre Neto <<a shape="rect" href="mailto:senhor.neto@gmail.com" rel="nofollow" target="_blank">senhor.neto@gmail.com</a>> wrote:<br clear="none"></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hello Marc,</div><div><br clear="none"></div><div>Can you share your table SQL definition?<br clear="none"></div><div>My gut feeling is that you might not have a unique identifier column.<br clear="none"></div><div><br clear="none"></div><div>Alexandre Neto</div><div>QGIS Support</div><div><a shape="rect" href="http://www.cooperative.net" rel="nofollow" target="_blank">www.cooperative.net</a><br clear="none"></div></div><br clear="none"><div><div dir="ltr">On Sun, Mar 7, 2021 at 9:51 PM Marc Millas <<a shape="rect" href="mailto:marc.millas@mokadb.com" rel="nofollow" target="_blank">marc.millas@mokadb.com</a>> wrote:<br clear="none"></div><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<div>I may be missing something more than obvious, but ...</div><div>QGIS 3.16 on win 10, postgres 12 with postgis 3.1 (same, machine (intel core i9, 64 GB ram, 6TB SSD))</div><div>a postgis table with a column geography(multipolygon, 4326)</div><div>-no pb to display this as a layer over whatever map (OSM standard as an exemple).</div><div>-no pb in qgis to go to edition mode, and add a few new polygons, edit the table fields and save. fine.</div><div>When I want to edit (ie. change..) one of the existing polygons, I:</div><div>--ask to go to edit mode with right click on that postgis layer</div><div>--select one of the existing polygons, (after choosing the select entity icon)</div><div>--??? according to the doc, I should click on the edit node icon. Which is grayed.</div><div>the qgis postgres user have all rights to write (proof by the inserts done)</div><div><br clear="none"></div><div>So.. there is something obvious somewhere, but I need some help to guess where :-)</div><div>thanks for your help,</div><div>regards,</div><div><br clear="none"></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr">Marc MILLAS<div>Senior Architect</div><div>+33607850334</div><div><a shape="rect" href="http://www.mokadb.com" rel="nofollow" target="_blank">www.mokadb.com</a></div><div><br clear="none"></div></div></div></div></div></div></div></div>
_______________________________________________<br clear="none">
Qgis-user mailing list<br clear="none">
<a shape="rect" href="mailto:Qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">Qgis-user@lists.osgeo.org</a><br clear="none">
List info: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none">
Unsubscribe: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none">
</blockquote></div>
</blockquote></div></div>
</div></div><div id="gmail-m_-5428697268660285684ydp67d598bdyqt78641">_______________________________________________<br clear="none">Qgis-user mailing list<br clear="none"><a shape="rect" href="mailto:Qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">Qgis-user@lists.osgeo.org</a><br clear="none">List info: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none">Unsubscribe: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none"></div></div>
</div>
</div></div></blockquote></div>