My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 68: disparities between sqlite3 postgres 8.3
1 person starred this issue and may be notified of changes. Back to list
Status:  Chatting
Owner:  ----


 
Reported by cou...@gmail.com, Feb 9, 2010
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 


Feb 10, 2010
#1 cou...@gmail.com
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 !
Sep 2, 2010
Project Member #2 craig.ds@gmail.com
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
Status: Chatting

Powered by Google Project Hosting