[Biopython-dev] [Bug 2849] PyGresql PostgreSQL driver support for BioSQL is broken
bugzilla-daemon at portal.open-bio.org
bugzilla-daemon at portal.open-bio.org
Thu Jun 4 11:05:11 UTC 2009
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.
More information about the Biopython-dev
mailing list