Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Carlo A. Bertelli (Charta s.r.l.)
iting 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 <aperi2...@gmail.com> >> > To: Matthias Kuhn <matth...@opengis.ch> >> > Cc: qgis-user <qgis-user@lists.osgeo.org> >> > Subject: Re: [Qgis-user] Editing a Postgis view >> > Message-ID: >> >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Andrea Peri
te, 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 <aperi2...@gmail.com> > > To: Matthias Kuhn <matth...@opengis.ch> > > Cc: qgis-user <qgis-user@lists.osgeo.org> > > Subject: Re: [Qgis-user] Editing a Postgis view > > Message-ID: > >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Nyall Dawson
ual for the instructions. >> > c >> > >> > Message: 6 >> > Date: Wed, 16 Nov 2016 09:39:23 +0100 >> > From: Andrea Peri <aperi2...@gmail.com> >> > To: Matthias Kuhn <matth...@opengis.ch> >> > Cc: qgis-user <qgis-user@lists.osgeo.org> >> > Subject: Re: [Qgis-user] Editing a Postgis view >> > Message-ID: >> >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Carlo A. Bertelli (Charta s.r.l.)
ctions. > > c > > > > Message: 6 > > Date: Wed, 16 Nov 2016 09:39:23 +0100 > > From: Andrea Peri <aperi2...@gmail.com> > > To: Matthias Kuhn <matth...@opengis.ch> > > Cc: qgis-user <qgis-user@lists.osgeo.org> > > Subject: Re: [Qgis-user] Editing a Postgis view > > Message-ID: > >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Nyall Dawson
in the Postgresql Reference Manual for the instructions. > c > > Message: 6 > Date: Wed, 16 Nov 2016 09:39:23 +0100 > From: Andrea Peri <aperi2...@gmail.com> > To: Matthias Kuhn <matth...@opengis.ch> > Cc: qgis-user <qgis-user@lists.osgeo.org> > Subject: Re: [Qgis-user] Editing a Postgis view > Message-ID: >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Carlo A. Bertelli (Charta s.r.l.)
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 <aperi2...@gmail.com> > > To: Matthias Kuhn <matth...@opengis.ch> > > Cc: qgis-user <qgis-user@lists.osgeo.org> > > Subject: Re: [Qgis-user] Editing a Postgis view > > Message-ID: > >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Andrea Peri
> > Message: 6 > Date: Wed, 16 Nov 2016 09:39:23 +0100 > From: Andrea Peri <aperi2...@gmail.com> > To: Matthias Kuhn <matth...@opengis.ch> > Cc: qgis-user <qgis-user@lists.osgeo.org> > Subject: Re: [Qgis-user] Editing a Postgis view > Message-ID: >

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Carlo A. Bertelli (Charta s.r.l.)
Reference Manual for the instructions. c Message: 6 Date: Wed, 16 Nov 2016 09:39:23 +0100 From: Andrea Peri <aperi2...@gmail.com> To: Matthias Kuhn <matth...@opengis.ch> Cc: qgis-user <qgis-user@lists.osgeo.org> Subject: Re: [Qgis-user] Editing a Postgis view Message-ID:

Re: [Qgis-user] Editing a Postgis view

2016-11-16 Thread Andrea Peri
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

Re: [Qgis-user] Editing a Postgis view

2016-11-15 Thread Matthias Kuhn
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.

[Qgis-user] Editing a Postgis view

2016-11-15 Thread Andrea Peri
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