[Qgis-user] Editing a Postgis view

[Nyall Dawson]

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/20161117/fb3a3b35/attachment.html>