dabo Commit
Revision 5285
Date: 2009-07-01 11:54:08 -0700 (Wed, 01 Jul 2009)
Author: Johnf
Trac: http://trac.dabodev.com/changeset/5285

Changed:
U   trunk/dabo/db/dbPostgreSQL.py

Log:
the getFields method was leaving the connection in a "<IDLE> in 
transaction".  This most likely was not harming Dabo transactions but was 
stopping other apps from working correctly.  To insure that the connection 
returned to a "<IDLE>" state I issue a rollback.  This should do no harm - but 
if anyone has an issue please post.

Diff:
Modified: trunk/dabo/db/dbPostgreSQL.py
===================================================================
--- trunk/dabo/db/dbPostgreSQL.py       2009-07-01 16:28:31 UTC (rev 5284)
+++ trunk/dabo/db/dbPostgreSQL.py       2009-07-01 18:54:08 UTC (rev 5285)
@@ -213,6 +213,7 @@
                        else:
                                fldType = "?"
                        fields.append((name, fldType, pk))
+               cursor.execute('rollback')
                return tuple(fields)
 
 




_______________________________________________
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]

Reply via email to