[Qgis-user] noobs -- question

[Marc Millas]

Fine !
it does work.
thanks for your help,

regards

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com



On Mon, Mar 8, 2021 at 2:09 AM Brent Wood <pcreso at yahoo.com> wrote:

> 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 MILLAS
> Senior Architect
> +33607850334
> www.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 Neto
> QGIS Support
> www.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 MILLAS
> Senior Architect
> +33607850334
> www.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/8699f651/attachment-0001.html>