On Friday, November 26, 2010 04:30:18 pm Jacek Kałucki wrote: > 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.
I will commit the change based on your log. I see no harm and Ed suggested I did it wrong anyway. However, I do NOT see the same results in my logs and I wonder why? I noticed that the logs are from different databases on different ports. Do you have two postgress instances and are they same versions? Johnf Johnf _______________________________________________ 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]
