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 <pcr...@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.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 MILLAS > Senior Architect > +33607850334 > www.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 Neto > QGIS Support > www.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 MILLAS > Senior Architect > +33607850334 > www.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