[Qgis-user] Editing a Postgis view

Andrea Peri aperi2007 at gmail.com
Wed Nov 16 11:36:37 PST 2016


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.html>


More information about the Qgis-user mailing list