[Biopython-dev] [Bug 2849] PyGresql PostgreSQL driver support for BioSQL is broken

[bugzilla-daemon at portal.open-bio.org]

http://bugzilla.open-bio.org/show_bug.cgi?id=2849





------- Comment #11 from cymon.cox at gmail.com  2009-06-05 06:08 EST -------
(In reply to comment #10)
> (From update of attachment 1320 [details])
> Good work - checked in, thanks.
> 
> One minor thing - do we have to do this:
> server.adaptor.cursor.execute("COMMIT")
> 
> rather than something like:
> server.adaptor.commit()
> 
> (I guess you had your reasons, and may have been doing this deliberately.)

Committing on the adaptor doesnt work: when the code goes to drop the db, it
throws a usual "cannot run inside a transaction block".

So it appears the commit must be made on the cursor.

Cheers, C.


-- 
Configure bugmail: http://bugzilla.open-bio.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.