[Gnumed-devel] a note on pyPgSQL

[Karsten Hilbert]

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