<div dir="ltr"><div>Oh, I see my master is old. I thought I recompiled it last week. I'll check again. Let's compile. <br></div><div>Regards</div><div>Régis<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 11 févr. 2020 à 15:12, Alessandro Pasotti <<a href="mailto:apasotti@gmail.com">apasotti@gmail.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><br></div><div>Wierd, I thought I fixed that: there is a test too, <a href="https://github.com/qgis/QGIS/pull/34017/files#diff-99b101819133a316786604243f3abf6eR1432" target="_blank">https://github.com/qgis/QGIS/pull/34017/files#diff-99b101819133a316786604243f3abf6eR1432</a></div><div><br></div><div>feel free to reopen and provide additional test details or test cases.</div><div><br></div><div><a href="https://github.com/qgis/QGIS/pull/34017" target="_blank">https://github.com/qgis/QGIS/pull/34017</a></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Feb 11, 2020 at 3:05 PM Régis Haubourg <<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>For the record here are my SQL commands:</div><div>drop table if exists data.pipe;</div><div><br></div><span style="font-family:monospace">CREATE TABLE data.pipe<br>(<br> id integer NOT NULL ,<br> label_1_text character varying(120) COLLATE pg_catalog."default",<br> _length2d numeric(8,2) GENERATED ALWAYS AS (st_length2D(geometry)) STORED,<br> _length3d numeric(8,2) GENERATED ALWAYS AS (ST_3DLength(geometry)) STORED,<br> geometry geometry(LineStringZ,3946) NOT NULL,<br> CONSTRAINT pipe_pkey PRIMARY KEY (id)<br></span><div><span style="font-family:monospace">);</span></div><div><br></div><div><span style="font-family:monospace">INSERT INTO "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d") VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),2 ,'test',DEFAULT, DEFAULT); </span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 11 févr. 2020 à 15:03, Régis Haubourg <<a href="mailto:regis.haubourg@gmail.com" target="_blank">regis.haubourg@gmail.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Paolo, <br></div><div>nice feature, thanks for the heads up !</div><div><br></div><div>I confirm the behavior here. <br></div><div><br></div><div>The documentation advises to use the `DEFAULT` keyword into the INSERT command. <br></div><div>Here is what I get with a QGIS-like insert :</div><div><br></div><div><span style="font-family:monospace"> INSERT INTO "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d") VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),1 ,'test',0, 0); <br>ERREUR: 42601: ne peut pas insérer dans la colonne « _length2d »<br>DÉTAIL : Column "_length2d" is a generated column.<br>EMPLACEMENT : rewriteTargetListIU, rewriteHandler.c : 827</span></div><div><br></div><div>With the keyword 'DEFAULT', it works <br></div><div><br></div><div><span style="font-family:monospace">INSERT INTO "data"."pipe"("geometry","id","label_1_text","_length2d","_length3d") VALUES (st_geomfromtext('LINESTRINGZ(1 1 1, 2 2 2)',3946),2 ,'test',DEFAULT, DEFAULT); <br></span></div><div><span style="font-family:monospace"><br></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif">And with no data supplied for the generated columns, it also works <br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif"><br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif">We indeed have to upgrade the postgresql provider to check this particular column type to handle INSERT and UPDATE accordingly. <br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif"><br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif">Regards</font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif"><br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif">Régis<br></font></span></div><div><span style="font-family:monospace"><font face="arial,sans-serif"></font><br></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mar. 11 févr. 2020 à 13:59, Paolo Cavallini <<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi all,<br>
PostgreSQL 12 has the option of a GENERATED ALWAYS AS ... STORED column.<br>
QGIS is able to load the table, but apparently it is not possible to<br>
insert new records. Does anyone confirm that this is not a local problem?<br>
All the best.<br>
-- <br>
Paolo Cavallini - <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a><br>
<a href="http://QGIS.ORG" rel="noreferrer" target="_blank">QGIS.ORG</a> Chair:<br>
<a href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" rel="noreferrer" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a><br>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div>
</blockquote></div>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div><br clear="all"><br>-- <br><div dir="ltr">Alessandro Pasotti<br>w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a></div>
</blockquote></div>