[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] a note on pyPgSQL
From: |
Horst Herb |
Subject: |
Re: [Gnumed-devel] a note on pyPgSQL |
Date: |
Tue, 24 Sep 2002 08:07:16 +1000 |
User-agent: |
KMail/1.4.6 |
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