| Issue 68: | disparities between sqlite3 postgres 8.3 | |
| 1 person starred this issue and may be notified of changes. | Back to list |
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
Sep 2, 2010
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
Dec 18, 2010
Migrated to https://github.com/django-mptt/django-mptt/issues/#issue/91 |
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 !