[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 #3 from biopython-bugzilla at maubp.freeserve.co.uk  2009-06-04 07:12 EST -------
(In reply to comment #2)
> (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.

Did you try it anyway?

http://www.postgresql.org/docs/7.0/interactive/sql-dropdatabase.html
http://www.postgresql.org/docs/8.3/interactive/sql-dropdatabase.html

This says "DROP DATABASE cannot be executed inside a transaction block.", which
is fine - we don't want a transaction for this as we won't ever roll this back.
It also says "This command cannot be executed while connected to the target
database." which should be fine.

[Maybe I need to setup my own machine with PostgreSQL on it for testing...]

Peter


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