I have a similar case to what is shown in the doc, here my slightly 
different usecase, see the commit for u3 and a final rollback.

Session = sessionmaker()
sess = Session()
sess.add(u1)
sess.add(u2)

sess.begin_nested() # establish a savepoint
sess.add(u3)  # in my case this is data I would like to keep regardless if 
later a rollback is done.
sess.commit()  # or rollback affecting u3, does not affect u1 or u2

sess.rollback() # I guessed/hoped that this would only affect u1 and u2, 
however it rolls back also u3


I am on Firebird SQL 2.1.

Should this work as I am hoping it is (in which case I will need to track it 
down further in my program), or is SAVEPOINT
not supported by FB?

Best regards
Werner



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to