[147] in Moira
dcm INGRES ERROR 5932
daemon@ATHENA.MIT.EDU (Mark Rosenstein)
Mon Aug 6 12:12:43 1990
Date: Mon, 6 Aug 90 12:12:05 -0400
From: Mark Rosenstein <mar@MIT.EDU>
To: jtkohl@ATHENA.MIT.EDU
Cc: jtkohl@ATHENA.MIT.EDU, bug-moira@ATHENA.MIT.EDU
In-Reply-To: John T Kohl's message of Sat, 4 Aug 90 02:01:07 -0400 <9008040601.AA18383@LYCUS.MIT.EDU>
From the manual: "The 'set autocommit on' command causes an implicit
commit to occur after every successfully executed SQL query. The
default is 'set autocommit off', which means that an explicit command
is required to commit a transaction."
I assume that means that each of the many quel queries that make up a
moira query would be independantly commited transactions at the DBMS
level. This is wrong, as it makes it impossible for moira to abort a
transaction in progress.
I haven't actually tried any of this with Ingres 6.2 to know what will
happen. I'm still trying to get a machine set up that I can run it
on.
-Mark
