Użytkownik John Fabiani napisał: > On Friday, November 26, 2010 03:57:31 pm Jacek Kałucki wrote: >> Użytkownik John Fabiani napisał: >>> self.rollbackTransaction(cursor) >>> I'm confused how does that change anything? >> Just look into backend log before and after change. > Please post what you see that changed - maybe your pg log. I do NOT > see a > difference in my logs. Also I sent you a copy of what pgAdmin is > reporting > and again I do not see a difference. The "IDLE in transaction" is > still open. > It maybe that I used the cursor rather than the connection but the > results > stay the same. > > Maybe we are looking for different results? I was concerned with open > the > query transaction. Is it you believe this change will fix your > problem with > losing data?
This is log: http://dabo.codepad.org/xLLp6n6M As you see, changing this single line causes that psycopg starts transactions automatically again after every ROLLBACK. This won't happen if you issue "execute('rollback')". There is no more "there is no transaction in progress" message. And yes, my data are now happy persisted. -- Regards Jacek Kałucki _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
