[Qgis-user] Qgis-user Digest, Vol 129, Issue 34
Ferruccio Sarra
ferruccio.sarra at gmail.com
Wed Nov 16 18:45:13 PST 2016
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, <qgis-user-request at lists.osgeo.org> wrote:
> Send Qgis-user mailing list submissions to
> qgis-user at lists.osgeo.org
>
> 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
> qgis-user-request at lists.osgeo.org
>
> You can reach the person managing the list at
> qgis-user-owner at lists.osgeo.org
>
> 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.)" <carlo.bertelli at gmail.com>
> To: qgis-user <qgis-user at lists.osgeo.org>
> Cc: Andrea Peri <aperi2007 at gmail.com>, Nyall Dawson
> <nyall.dawson at gmail.com>
> Subject: Re: [Qgis-user] Editing a Postgis view
> Message-ID:
> <CALc8-VLiWF+LtC=EJhfRAD5uuXB-+zBJ95c11i7R7FhnJh8dSA at 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 <nyall.dawson at gmail.com>
> wrote:
>
> > On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" <
> > carlo.bertelli at gmail.com> 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 <aperi2007 at gmail.com>
> > > To: Matthias Kuhn <matthias at opengis.ch>
> > > Cc: qgis-user <qgis-user at lists.osgeo.org>
> > > Subject: Re: [Qgis-user] Editing a Postgis view
> > > Message-ID:
> > > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=tUGWwcKd
> > -WA at mail.gmail.com>
> > > 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 <matthias at opengis.ch>:
> > > > 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
> > > > Qgis-user at lists.osgeo.org
> > > > 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 <nyall.dawson at gmail.com>
> To: "Carlo A. Bertelli" <carlo.bertelli at gmail.com>
> Cc: qgis-user <qgis-user at lists.osgeo.org>, Andrea Peri
> <aperi2007 at gmail.com>
> Subject: Re: [Qgis-user] Editing a Postgis view
> Message-ID:
> <CAB28Ashbqne0XirM1ZowNjXebBCjPXLQDYV5QLJy=joEwTSjew at mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On 17 Nov 2016 4:45 AM, "Carlo A. Bertelli (Charta s.r.l.)" <
> carlo.bertelli at gmail.com> 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 <nyall.dawson at gmail.com>
> wrote:
> >>
> >> On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" <
> carlo.bertelli at gmail.com> 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 <aperi2007 at gmail.com>
> >> > To: Matthias Kuhn <matthias at opengis.ch>
> >> > Cc: qgis-user <qgis-user at lists.osgeo.org>
> >> > Subject: Re: [Qgis-user] Editing a Postgis view
> >> > Message-ID:
> >> > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=
> tUGWwcKd-WA at mail.gmail.com>
> >> > 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 <matthias at opengis.ch>:
> >> > > 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
> >> > > Qgis-user at lists.osgeo.org
> >> > > 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 <aperi2007 at gmail.com>
> To: Nyall Dawson <nyall.dawson at gmail.com>
> Cc: qgis-user <qgis-user at lists.osgeo.org>, carlo.bertelli at gmail.com,
> Andrea Peri <aperi2007 at gmail.com>
> 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" <nyall.dawson at gmail.com> ha scritto:
>
> > On 17 Nov 2016 12:54 AM, "Carlo A. Bertelli (Charta s.r.l.)" <
> > carlo.bertelli at gmail.com> 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 <aperi2007 at gmail.com>
> > > To: Matthias Kuhn <matthias at opengis.ch>
> > > Cc: qgis-user <qgis-user at lists.osgeo.org>
> > > Subject: Re: [Qgis-user] Editing a Postgis view
> > > Message-ID:
> > > <CABqTJk8Bo7fs6qOG=MhO9N50qO5L+JkXAOAgik=tUGWwcKd
> > -WA at mail.gmail.com>
> > > 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 <matthias at opengis.ch>:
> > > > 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
> > > > Qgis-user at lists.osgeo.org
> > > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > >
> > >
> > > _______________________________________________
> > > Qgis-user mailing list
> > > Qgis-user at lists.osgeo.org
> > > 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
> Qgis-user at lists.osgeo.org
> 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
> ******************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161117/8beb1a2d/attachment.html>
More information about the Qgis-user
mailing list