On Apr 7, 2011, at 9:54 PM, BenH wrote: > Hi, > > I have an objects that when I convert to a string using __repr__ > throws a DetachedInstanceError. If I access any of their members or > test the session (using 'user in Session') everything is fine but if I > check 'self in Session' in __repr__ the result is False. > I can reattach it to the Session using merge, inside the __repr__ > call, but every time I call repr I get the same problem. > > I'm using PostgreSQL 8.4 and SqlAlchemy 0.6.4 and I'm using Pylons > 1.0. I have a nested transaction (using Session.begin_nested) that is > updating objects that are attached to a User object but that don't > change the user object itself but the problem is seen in other, > unrelated objects. Other than the nested transaction there are no > other flushes or commits. > > Does anybody have any idea what is going on?
if you're doing any session.close() or session.expunge(), whatever references you have left after that aren't in the session. that's the only way you can end up with detachment errors. also, pulling objects in and out of caches, across processes with pickle, stuff like that, can introduce detached objects. merge() doesn't reattach objects either it returns a new object that is associated with the session. the one you send stays detached (if it was already). > > Thanks, > > Ben > > -- > 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 > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
