disparities between sqlite3 postgres 8.3

google-code-export / django-mptt

Automatically exported from code.google.com/p/django-mptt

Other

0 stars 0 forks source link

disparities between sqlite3 postgres 8.3 #68

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

I have differences in my tree order between dev and prod version.

Using the same code (model) and imported data (loaddata json) i get the
good ordering ('tree_id','lft') in sqlite3:

Math
 - 6 ieme
 - 5 ieme
 - 4 ieme
 - ...
 - prepa
 - autres

While in postgres i get:

Math
 - Terminal S
 - Terminal ES
 - Terminal L
 - ...
 - prepa
 - autres
 - 6 ieme
 - 5 ieme
 - 4 ieme
 - ...

i tried using rebuild patch, but it does not change this behavior.

Wondering what can i do about it ?, i will try on postgres 8.1

Original issue reported on code.google.com by cou...@gmail.com on 10 Feb 2010 at 7:22

GoogleCodeExporter commented 9 years ago

I had to hack managers.py get_query_set to force order_by("id","-lft")
I dont know why i have to do this, in sqlite lft and right attributes are 
reversed !

Original comment by cou...@gmail.com on 10 Feb 2010 at 12:00

GoogleCodeExporter commented 9 years ago

coulix

Did you make any progress with this?

If not, can you please try again with the latest source checkout from 
http://github.com/django-mptt/django-mptt/ and let us know if the problem still 
occurs?

Thanks

Original comment by craig.ds@gmail.com on 2 Sep 2010 at 12:51

Changed state: Chatting

GoogleCodeExporter commented 9 years ago

Migrated to https://github.com/django-mptt/django-mptt/issues/#issue/91

Original comment by craig.ds@gmail.com on 19 Dec 2010 at 1:09