Re: [QGIS-Developer] Bug in DB Manager > Versioning?

2018-01-29 Thread Paolo Cavallini
Il 26/01/2018 08:43, Paolo Cavallini ha scritto: > Il 25/01/2018 20:39, Jürgen E. Fischer ha scritto: > >> id should still be unique for all current rows, shouldn't it? > > it should, but in the tests we have done it isn't: we end up having > 1 > record with the same id and NULL time_end. Apparen

Re: [QGIS-Developer] Bug in DB Manager > Versioning?

2018-01-25 Thread Paolo Cavallini
Il 25/01/2018 20:39, Jürgen E. Fischer ha scritto: > id should still be unique for all current rows, shouldn't it? it should, but in the tests we have done it isn't: we end up having > 1 record with the same id and NULL time_end. Apparently this happens when a polygon is split into > 1. All the b

Re: [QGIS-Developer] Bug in DB Manager > Versioning?

2018-01-25 Thread Jürgen E . Fischer
Hi Paolo, On Thu, 25. Jan 2018 at 20:29:00 +0100, Paolo Cavallini wrote: > ALTER TABLE "public"."province_hist" ADD "id_hist" serial, ADD > "time_start" timestamp, ADD "time_end" timestamp; > > ALTER TABLE "public"."province_hist" DROP CONSTRAINT > "province_hist_pkey", ADD PRIMARY KEY ("id_hist"

[QGIS-Developer] Bug in DB Manager > Versioning?

2018-01-25 Thread Paolo Cavallini
Hi all, the Versioning menu replaces the original primary key with a new one, leaving the original id as a non PK field: ALTER TABLE "public"."province_hist" ADD "id_hist" serial, ADD "time_start" timestamp, ADD "time_end" timestamp; ALTER TABLE "public"."province_hist" DROP CONSTRAINT "province_

Re: [Qgis-developer] Bug in DB Manager versioning?

2014-01-27 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 25/01/2014 11:20, Gino Pirelli ha scritto: > it works on my compiled version 8b53001 > > do you have e more detailed test case? Yes, we have tested both on Windows and Debian, same results. QGIS 2.0.1, PostGIS 2.1.1 Thanks. - -- Paolo Cavallini

Re: [Qgis-developer] Bug in DB Manager versioning?

2014-01-25 Thread Gino Pirelli
it works on my compiled version 8b53001 do you have e more detailed test case? ciao Luigi Pirelli (luigi.pire...@faunalia.it - lui...@gmail.com) On 24 January 2014 16:40, Paolo Cavallini wrote: > Hi all. > Activating versioning in DB Manager throws an error: > language "SQL" does not exist

[Qgis-developer] Bug in DB Manager versioning?

2014-01-24 Thread Paolo Cavallini
Hi all. Activating versioning in DB Manager throws an error: language "SQL" does not exist Does anybody confirm? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-developer mailing list Qgi