<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
pgversion is a nice approach and there is a QGIS plugin too.<br>
<br>
I tried it a couple of years ago and I liked it.<br>
It is programmed using plpgsql so you can improve it or study the
source code easily<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.kappasys.ch">http://www.kappasys.ch</a><br>
<br>
<br>
<div class="moz-cite-prefix">On 05/06/2014 18:43, Alexandre Neto
wrote:<br>
</div>
<blockquote
cite="mid:CA+H0G_EsfCB2MOqAk1WfMLEg6OoosVmTqaFVrfvZ0Tw2EssHxg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hello all,</div>
<div><br>
</div>
I have been working on a versioning system to be used with QGIS.
<div><br>
</div>
<div>This is probably a very naive approach since I'm no expert
in Postgres, but I would like to ear some comments and
suggestions to improve it.</div>
<div><br>
</div>
<div>The work is based on the versioning system of QGIS, but I
wanted to improve two things:</div>
<div><br>
</div>
<div>1 - Keep always the same primary key of features;</div>
<div>2 - Only save\backup changed columns instead of the full
similar rows;</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks for your help</div>
<div><br>
</div>
<div>Alexandre Neto</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
------------------------------
José Carlos Martínez Llario
<a class="moz-txt-link-freetext" href="http://cartosig.upv.es">http://cartosig.upv.es</a>
Producción Cartográfica y SIG.
Dpto. Ingeniería Cartográfica.
Univ. Politécnica de Valencia.
------------------------------</pre>
</body>
</html>