[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 #2 from cymon.cox at gmail.com  2009-06-04 07:05 EST -------
(In reply to comment #1)
> We don't really need the auto commit statement in the unit test, what happens
> on your machine if you remove it?

I think we do need it for psycopg/psycopg2, as the comment says, postgresql
cannot drop a database inside a transaction:

INTERNAL ERROR: DROP DATABASE cannot run inside a transaction block

C.

> 
> RCS file: /home/repository/biopython/biopython/Tests/test_BioSQL.py,v
> retrieving revision 1.41
> diff -r1.41 test_BioSQL.py
> 54,59d53
> <     # Auto-commit: postgresql cannot drop database in a transaction
> <     try:
> <         server.adaptor.autocommit()
> <     except AttributeError:
> <         pass
> < 
> 
> With the above change MySQL is happy.
> 


-- 
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.