<html><body><html><head><meta name="viewport" content="width=device-width" /><meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8" /></head><body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">I seem to remember a begin end transaction in early versions of Ingres. <br>
<br>
I think a transaction starts immediately ABF or isql are launched. Or immediately after a commit. But perhaps someone will correct me.<br>
Allan<br>
-- <br>
Sent from my Android phone with <a href="http://mail.com">mail.com</a> Mail. Please excuse my brevity.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em">On 12/10/2018, 20:48 nikosv <nikos.vaggalis@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I've noticed that in the environment that these glitches occur has the default SET SESSION with ON_ERROR= rollback statement;<br />
not<br />
SET SESSION with ON_ERROR= rollback transaction;<br />
which might explain what's happening, but I have to investigate further.<br />
<br />
In general, when you open a persistent abf or isql session, what is Ingres considering as the beginning of a transaction given the absence of the begin/end transaction statements?<br />
<br />
When you manually rollback as in "inquire_ingres (h_rowcount = rowcount, h_errorno = errorno)" and "if (h_errorno!=0) then rollback" is the set session directive honored?<br />
_______________________________________________<br />
Info-ingres mailing list<br />
Info-ingres@lists.planetingres.org<br />
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br />
</blockquote></div></body></html></body></html>