Hi, I already quit the list by unsubscrbing in the mailman server. Neverthwless I am still receiving messages. Could anyone help me to unsubscribe completely?
Thanks. Ferruccio On 16 Nov 2016 23:01, <[email protected]> wrote: > Send Qgis-user mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.osgeo.org/mailman/listinfo/qgis-user > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Qgis-user digest..." > > > Today's Topics: > > 1. Re: Editing a Postgis view (Carlo A. Bertelli (Charta s.r.l.)) > 2. Re: Editing a Postgis view (Nyall Dawson) > 3. Re: Editing a Postgis view (Andrea Peri) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 16 Nov 2016 19:45:17 +0100 > From: "Carlo A. Bertelli (Charta s.r.l.)" <[email protected]> > To: qgis-user <[email protected]> > Cc: Andrea Peri <[email protected]>, Nyall Dawson > <[email protected]> > Subject: Re: [Qgis-user] Editing a Postgis view > Message-ID: > <CALc8-VLiWF+LtC=EJhfRAD5uuXB-+zBJ95c11i7R7FhnJh8dSA@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Thank you Nyall for fixing my "conservative" and unduly generalised > assumption. > A thought it was an older version, as updatable views handle > rules/sequences with some careful nonchalance, especially for views on a > table only. > Unfortunately no database can handle logic problems at the conceptual > level. I don't know if a future version of any RDBMS wil... > c > > On Wed, Nov 16, 2016 at 7:22 PM, Nyall Dawson <[email protected]> > wrote: > > > On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" < > > [email protected]> wrote: > > > > > > Ciao Andrea, > > > by default Postgresql views are read only. Even the simplest view made > > in Postgresql needs a rule to be updated. > > > > That's not quite correct. Recent versions of postgres make simple views > > editable. > > See > > > > https://www.depesz.com/2012/12/11/waiting-for-9-3-support- > > automatically-updatable-views/ > > > > Nyall > > > > After writing a statement for a view, just take the habit of writing the > > rules for insert, update, delete. > > > Please read the chapter on the Rule System in the Postgresql Reference > > Manual for the instructions. > > > c > > > > > > Message: 6 > > > Date: Wed, 16 Nov 2016 09:39:23 +0100 > > > From: Andrea Peri <[email protected]> > > > To: Matthias Kuhn <[email protected]> > > > Cc: qgis-user <[email protected]> > > > Subject: Re: [Qgis-user] Editing a Postgis view > > > Message-ID: > > > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=tUGWwcKd > > [email protected]> > > > Content-Type: text/plain; charset=UTF-8 > > > > > > Hi Matthias, > > > thx for response. > > > So the trouble is in my db. > > > > > > Now I try to understand better why it is not working. > > > > > > This is my actual try test: > > > > > > create table schemaapp.repository( > > > ID serial primary key NOT NULL, > > > UUID varchar(50) NOT NULL, > > > PROGETTO varchar(9) NOT NULL, > > > PROCEDIMENTO text NOT NULL, > > > GEOMETRIA1 geometry(MULTIPOINT, 3003) > > > ); > > > > > > create view schemaapp.v_repository_point as > > > select > > > a.id as id, > > > a.uuid as uuid, > > > a.progetto as progetto, > > > a.procedimento as procedimento, > > > a.geometria1 as geometria > > > from > > > schemappa.repository_wfs as a > > > where > > > a.geometria1 is not null; > > > > > > I will know if discover something. > > > thx again. > > > > > > 2016-11-16 8:54 GMT+01:00 Matthias Kuhn <[email protected]>: > > > > Hi Andrea, > > > > > > > > It works here. > > > > Do you have an instead of insert rule written on your view? > > > > It works for me this way (but my views are too complicated for > postgres > > > > to create default insert rules by default anyway). > > > > You can also try to alter your view with a default value for the > column > > > > in question. > > > > > > > > Best regards > > > > Matthias > > > > > > > > On 11/16/2016 08:15 AM, Andrea Peri wrote: > > > >> Hi, > > > >> I'm having some trouble to edit a postgis view using qgis. > > > >> > > > >> The view is a simple: > > > >> select list-of-field from table1; > > > >> > > > >> And the table1 is a table with a Primary key on a serial type field. > > > >> > > > >> I add the first record and all was ok. The commit too. > > > >> When go to add the second record. > > > >> I start to have trouble. > > > >> The qgis report my always a constraint violation of the pk. > > > >> I try to leave the pk field empty, or try to fill it with a value. > > > >> No solution work. > > > >> > > > >> So my question is if is confirmed that qgis (I use the 2.18) > version) > > > >> is working in editing with a postgis view . > > > >> > > > >> Thx. > > > >> A. > > > >> > > > >> > > > >> > > > > _______________________________________________ > > > > Qgis-user mailing list > > > > [email protected] > > > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20161116/2cea1f5a/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Thu, 17 Nov 2016 04:54:07 +1000 > From: Nyall Dawson <[email protected]> > To: "Carlo A. Bertelli" <[email protected]> > Cc: qgis-user <[email protected]>, Andrea Peri > <[email protected]> > Subject: Re: [Qgis-user] Editing a Postgis view > Message-ID: > <CAB28Ashbqne0XirM1ZowNjXebBCjPXLQDYV5QLJy=joEwTSjew@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > On 17 Nov 2016 4:45 AM, "Carlo A. Bertelli (Charta s.r.l.)" < > [email protected]> wrote: > > > > Thank you Nyall for fixing my "conservative" and unduly generalised > assumption. > > A thought it was an older version, as updatable views handle > rules/sequences with some careful nonchalance, especially for views on a > table only. > > Unfortunately no database can handle logic problems at the conceptual > level. I don't know if a future version of any RDBMS wil... > > Yes, it's a nice feature, but the very limited requirements when this kicks > in generally prevent it from being usable with real views. > > Nyall > > > c > > > > On Wed, Nov 16, 2016 at 7:22 PM, Nyall Dawson <[email protected]> > wrote: > >> > >> On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" < > [email protected]> wrote: > >> > > >> > Ciao Andrea, > >> > by default Postgresql views are read only. Even the simplest view made > in Postgresql needs a rule to be updated. > >> > >> That's not quite correct. Recent versions of postgres make simple views > editable. > >> See > >> > >> > https://www.depesz.com/2012/12/11/waiting-for-9-3-support- > automatically-updatable-views/ > >> > >> Nyall > >> > >> After writing a statement for a view, just take the habit of writing the > rules for insert, update, delete. > >> > Please read the chapter on the Rule System in the Postgresql Reference > Manual for the instructions. > >> > c > >> > > >> > Message: 6 > >> > Date: Wed, 16 Nov 2016 09:39:23 +0100 > >> > From: Andrea Peri <[email protected]> > >> > To: Matthias Kuhn <[email protected]> > >> > Cc: qgis-user <[email protected]> > >> > Subject: Re: [Qgis-user] Editing a Postgis view > >> > Message-ID: > >> > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik= > [email protected]> > >> > Content-Type: text/plain; charset=UTF-8 > >> > > >> > Hi Matthias, > >> > thx for response. > >> > So the trouble is in my db. > >> > > >> > Now I try to understand better why it is not working. > >> > > >> > This is my actual try test: > >> > > >> > create table schemaapp.repository( > >> > ID serial primary key NOT NULL, > >> > UUID varchar(50) NOT NULL, > >> > PROGETTO varchar(9) NOT NULL, > >> > PROCEDIMENTO text NOT NULL, > >> > GEOMETRIA1 geometry(MULTIPOINT, 3003) > >> > ); > >> > > >> > create view schemaapp.v_repository_point as > >> > select > >> > a.id as id, > >> > a.uuid as uuid, > >> > a.progetto as progetto, > >> > a.procedimento as procedimento, > >> > a.geometria1 as geometria > >> > from > >> > schemappa.repository_wfs as a > >> > where > >> > a.geometria1 is not null; > >> > > >> > I will know if discover something. > >> > thx again. > >> > > >> > 2016-11-16 8:54 GMT+01:00 Matthias Kuhn <[email protected]>: > >> > > Hi Andrea, > >> > > > >> > > It works here. > >> > > Do you have an instead of insert rule written on your view? > >> > > It works for me this way (but my views are too complicated for > postgres > >> > > to create default insert rules by default anyway). > >> > > You can also try to alter your view with a default value for the > column > >> > > in question. > >> > > > >> > > Best regards > >> > > Matthias > >> > > > >> > > On 11/16/2016 08:15 AM, Andrea Peri wrote: > >> > >> Hi, > >> > >> I'm having some trouble to edit a postgis view using qgis. > >> > >> > >> > >> The view is a simple: > >> > >> select list-of-field from table1; > >> > >> > >> > >> And the table1 is a table with a Primary key on a serial type > field. > >> > >> > >> > >> I add the first record and all was ok. The commit too. > >> > >> When go to add the second record. > >> > >> I start to have trouble. > >> > >> The qgis report my always a constraint violation of the pk. > >> > >> I try to leave the pk field empty, or try to fill it with a value. > >> > >> No solution work. > >> > >> > >> > >> So my question is if is confirmed that qgis (I use the 2.18) > version) > >> > >> is working in editing with a postgis view . > >> > >> > >> > >> Thx. > >> > >> A. > >> > >> > >> > >> > >> > >> > >> > > _______________________________________________ > >> > > Qgis-user mailing list > >> > > [email protected] > >> > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > >> > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20161117/fe1bae75/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Wed, 16 Nov 2016 20:36:37 +0100 > From: Andrea Peri <[email protected]> > To: Nyall Dawson <[email protected]> > Cc: qgis-user <[email protected]>, [email protected], > Andrea Peri <[email protected]> > Subject: Re: [Qgis-user] Editing a Postgis view > Message-ID: > <CABqTJk-pi3O52bvLQh6e_THM-Jrcmy_0eeSeV8G9mkXhwkctGQ@ > mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Thx for clarification. > My postgres is a 9.5 version. This explain why it has writable view. > > So i Need to try the role Instead of sinpky and often used serial type for > pk. > > A. > > Il 16 nov 2016 19:22, "Nyall Dawson" <[email protected]> ha scritto: > > > On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" < > > [email protected]> wrote: > > > > > > Ciao Andrea, > > > by default Postgresql views are read only. Even the simplest view made > > in Postgresql needs a rule to be updated. > > > > That's not quite correct. Recent versions of postgres make simple views > > editable. > > See > > > > https://www.depesz.com/2012/12/11/waiting-for-9-3-support- > > automatically-updatable-views/ > > > > Nyall > > > > After writing a statement for a view, just take the habit of writing the > > rules for insert, update, delete. > > > Please read the chapter on the Rule System in the Postgresql Reference > > Manual for the instructions. > > > c > > > > > > Message: 6 > > > Date: Wed, 16 Nov 2016 09:39:23 +0100 > > > From: Andrea Peri <[email protected]> > > > To: Matthias Kuhn <[email protected]> > > > Cc: qgis-user <[email protected]> > > > Subject: Re: [Qgis-user] Editing a Postgis view > > > Message-ID: > > > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=tUGWwcKd > > [email protected]> > > > Content-Type: text/plain; charset=UTF-8 > > > > > > Hi Matthias, > > > thx for response. > > > So the trouble is in my db. > > > > > > Now I try to understand better why it is not working. > > > > > > This is my actual try test: > > > > > > create table schemaapp.repository( > > > ID serial primary key NOT NULL, > > > UUID varchar(50) NOT NULL, > > > PROGETTO varchar(9) NOT NULL, > > > PROCEDIMENTO text NOT NULL, > > > GEOMETRIA1 geometry(MULTIPOINT, 3003) > > > ); > > > > > > create view schemaapp.v_repository_point as > > > select > > > a.id as id, > > > a.uuid as uuid, > > > a.progetto as progetto, > > > a.procedimento as procedimento, > > > a.geometria1 as geometria > > > from > > > schemappa.repository_wfs as a > > > where > > > a.geometria1 is not null; > > > > > > I will know if discover something. > > > thx again. > > > > > > 2016-11-16 8:54 GMT+01:00 Matthias Kuhn <[email protected]>: > > > > Hi Andrea, > > > > > > > > It works here. > > > > Do you have an instead of insert rule written on your view? > > > > It works for me this way (but my views are too complicated for > postgres > > > > to create default insert rules by default anyway). > > > > You can also try to alter your view with a default value for the > column > > > > in question. > > > > > > > > Best regards > > > > Matthias > > > > > > > > On 11/16/2016 08:15 AM, Andrea Peri wrote: > > > >> Hi, > > > >> I'm having some trouble to edit a postgis view using qgis. > > > >> > > > >> The view is a simple: > > > >> select list-of-field from table1; > > > >> > > > >> And the table1 is a table with a Primary key on a serial type field. > > > >> > > > >> I add the first record and all was ok. The commit too. > > > >> When go to add the second record. > > > >> I start to have trouble. > > > >> The qgis report my always a constraint violation of the pk. > > > >> I try to leave the pk field empty, or try to fill it with a value. > > > >> No solution work. > > > >> > > > >> So my question is if is confirmed that qgis (I use the 2.18) > version) > > > >> is working in editing with a postgis view . > > > >> > > > >> Thx. > > > >> A. > > > >> > > > >> > > > >> > > > > _______________________________________________ > > > > Qgis-user mailing list > > > > [email protected] > > > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > > > > > > _______________________________________________ > > > Qgis-user mailing list > > > [email protected] > > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20161116/679bf1a1/attachment-0001.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > ------------------------------ > > End of Qgis-user Digest, Vol 129, Issue 34 > ****************************************** >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
