<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hello Andreas,</div><div class=""><br class=""></div><div class="">yes it’s for some ‘historisation', more precisely to make a filiation, and yes I certainly will use triggers in PostGIS. But I wanted to avoid confusion between different kind of edition operations that I’m not currently foreseeing; I’m not sure it will always be easy to distinct this specific action from others. And I thought that it might also be interesting outside of the database world, to have that "edit and preserve" operation. </div><br class=""><div apple-content-edited="true" class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;">Didier<br class=""></span></div></div></div></div></div><br class="Apple-interchange-newline">
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">Le 20 juil. 2015 à 09:10, Neumann, Andreas <<a href="mailto:a.neumann@carto.net" class="">a.neumann@carto.net</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class=""><div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif" class=""><p class="">Hi Didier,</p><p class="">Is this for historisation purposes? If yes, I would look into database solutions to do historization.</p><p class="">The SQL-MM standard has this as a built-in tool set for databases, however, PostgreSQL does not implement this part of the SQL specification (I believe the latest versions of SQL server and Oracle 12 does). However, you can simulate the same in Postgis, using triggers and rules.</p><p class="">Andreas</p><p class="">On 2015-07-20 08:00, didier peeters wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0" class=""><!-- html ignored --><!-- head ignored --><!-- meta ignored -->Hello,
<div class=""> </div>
<div class="">I would like to find the best solution to the following case:</div>
<div class=""> </div>
<div class="">in QGis, when editing a polygon (splitting it in 2 parts) I need to save the original shape, in order to keep the different steps of its evolution; this operation is likely to be repeated several times. The solution I found is to </div>
<div class="">
<ul class="MailOutline">
<li class="">start by copying the polygon, </li>
<li class="">then edit it (split) </li>
<li class="">then pasting back the original one, </li>
<li class="">then adjust and update the attributes of the 2 new polygons. </li>
</ul>
<div class=""> </div>
</div>
<div class="">Is there a less tricky way to achieve this ? </div>
<div class=""> </div>
<div class="">If not it would be nice to have an option in the save dialog (with a default behaviour set in the Settings), and I would file a feature request. </div>
<div class=""> </div>
<div class="">Didier</div>
<!-- html ignored --><br class="">
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br class=""> Qgis-user mailing list<br class=""><a href="mailto:Qgis-user@lists.osgeo.org" class="">Qgis-user@lists.osgeo.org</a><br class=""><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote><div class=""> <br class="webkit-block-placeholder"></div>
<div class=""> </div>
</div>
</div></blockquote></div><br class=""></body></html>