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 > > > _______________________________________________ > 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
