Re: [Qgis-developer] Reverse order in PostGIS commit?

On Wed, Jul 9, 2014 at 1:40 AM, Jürgen E. wrote: > Hi Paolo, > > On Tue, 08. Jul 2014 at 15:48:22 +0200, Paolo Cavallini wrote: > > I have just noticed that when digitizing new shapes, they get written > > in a PostGIS table in a reverse order respect to the digitizing order; > > You refer to the

Re: [Qgis-developer] Reverse order in PostGIS commit?

Jurgen, I agree with Paolo. It is sensitive for any other data workflow which relies on this information. Edited data is not only reused within QGIS (where it may get loaded in a different order). giovanni 2014-07-10 17:03 GMT+02:00 Jürgen E. : > Hi George, > > On Thu, 10. Jul 2014 at 11:42:00

Re: [Qgis-developer] Reverse order in PostGIS commit?

Hello Jurgen! I can test this easily. I'll get back to you soon. On Thu, Jul 10, 2014 at 12:03 PM, Jürgen E. wrote: > Hi George, > > On Thu, 10. Jul 2014 at 11:42:00 -0300, George Silva wrote: > > This could affect custom database triggers or implementations. > > > Here we use an auditing sche

Re: [Qgis-developer] Reverse order in PostGIS commit?

Hi George, On Thu, 10. Jul 2014 at 11:42:00 -0300, George Silva wrote: > This could affect custom database triggers or implementations. > Here we use an auditing scheme to monitor perfomance of digitizing of our > users. > I agree with Paolo here, this gives a unpredicted result in some operati

Re: [Qgis-developer] Reverse order in PostGIS commit?

This could affect custom database triggers or implementations. Here we use an auditing scheme to monitor perfomance of digitizing of our users. I agree with Paolo here, this gives a unpredicted result in some operations that might exist. On Thu, Jul 10, 2014 at 10:46 AM, Paolo Cavallini wrote:

Re: [Qgis-developer] Reverse order in PostGIS commit?

On 07/10/2014 03:46 PM, Paolo Cavallini wrote: Il 09/07/2014 09:40, Jürgen E. Fischer ha scritto: You refer to the order of INSERTs? Why does that matter? The order in which you get back the feature after INSERT later is undefined anyway. Ideally the records should be inserted in the order

Re: [Qgis-developer] Reverse order in PostGIS commit?

Il 09/07/2014 09:40, Jürgen E. Fischer ha scritto: > You refer to the order of INSERTs? Why does that matter? The order in which > you get back the feature after INSERT later is undefined anyway. Ideally the records should be inserted in the order they have been digitized, to give the most pr

Re: [Qgis-developer] Reverse order in PostGIS commit?

Hi Paolo, On Tue, 08. Jul 2014 at 15:48:22 +0200, Paolo Cavallini wrote: > I have just noticed that when digitizing new shapes, they get written > in a PostGIS table in a reverse order respect to the digitizing order; You refer to the order of INSERTs? Why does that matter? The order in which

Re: [Qgis-developer] Reverse order in PostGIS commit?

Hi I wrote about this some time ago [1]. It seems that other providers are also affected by this. Regards Piotr [1] http://osgeo-org.1560.x6.nabble.com/Wrong-feature-order-after-commiting-changes-td5130555.html#a5131250

[Qgis-developer] Reverse order in PostGIS commit?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all. I have just noticed that when digitizing new shapes, they get written in a PostGIS table in a reverse order respect to the digitizing order; I kind of remember it was not a while a go: does anybody know if the behavious was changed on purpose?