Re: [Qgis-user] noobs -- question
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 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/36579817-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 > 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 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
Re: [Qgis-user] noobs -- question
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/36579817-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 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 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 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
Re: [Qgis-user] noobs -- question
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 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 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
Re: [Qgis-user] noobs -- question
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 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] noobs -- question
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