Custom SQL issues

[Karantir]

Hi, guys )

I'm expecting some troubles with performing custom SQL. Could you help
me please?

I'm using nested sets method to store tree in Postgres DB. So i've
wrote decorators for tree model manager to perform generic tree
functions like move, create, delete etc. It's strange, but when i'm
running move() function nothing happens with table data despite of
that (and i can see it) valid sql has executed and i have no error
reports, exceptions or something like this, so i have no idea where i
should search the source of my problem.

Any thoughts?

[Karantir]

I've just find out, that explicit transaction.commit() in my view
eliminates the problem. But i want django to commit pending
transactions automatically.

[Karantir]

adding transaction.commit_unless_management() to the end of my move()
function solve the problem.