[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] a note on pyPgSQL
From: |
Karsten Hilbert |
Subject: |
[Gnumed-devel] a note on pyPgSQL |
Date: |
Fri, 4 Oct 2002 17:19:39 +0200 |
User-agent: |
Mutt/1.3.22.1i |
For all those working on database stuff: Unlike other DB-API
adapters pyPgSQL does NOT auto-commit transactions upon
closing a cursor ! This bit me for quite some time. One needs
to to an explicit connection.commit() on things. On second
thought this makes a whole lot of sense since on
exceptions/unexpected return() pathes we won't get
auto-commits that should not have happened.
I am not sure about the "BEGIN TRANSACTION" semantics, though.
Probably a new transaction starts automatically after each
commit.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] a note on pyPgSQL,
Karsten Hilbert <=