Re: [Gnumed-devel] a note on pyPgSQL

[Horst Herb]

On Sat, 5 Oct 2002 01:19, Karsten Hilbert wrote:

> I am not sure about the "BEGIN TRANSACTION" semantics, though.
> Probably a new transaction starts automatically after each
> commit.

A new transaction starts when you request a cursor, and it ends when you call 
commit(). That is, unless you don't set autocommit to "on" - which you 
shouldn't in most cases.

You need "BEGIN TRANSACTION" only if you have several independend transactions 
within the same cursor object (don't know why and when one would need such 
thing) - you would use it from within an SQL statement.

Horst