[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 19:15:35 UTC 2009
http://bugzilla.open-bio.org/show_bug.cgi?id=2849
------- Comment #5 from cymon.cox at gmail.com 2009-06-04 15:15 EST -------
(In reply to comment #3)
> (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.
Psycopg defaults to a "read committed" isolation level that psycopg wraps in a
translation block. So, I think the only way not to be in a translation block is
to autocommit.
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.
More information about the Biopython-dev
mailing list