Ha, ha, ha, ha, ha, ha, ha, ha. Thank you very much Helen, sometimes the memory is not so good as was some years ago.
Ok, I now know and hope not forget again: "NEVER USE IN AUTONOMOUS TRANSACTION INSIDE A TRANSACTION RELATED DATABASE TRIGGER". Greetings. Walter. On Fri, Aug 7, 2015 at 11:20 PM, Helen Borrie hele...@iinet.net.au [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > At 02:51 p.m. 8/08/2015, 'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [f wrote: > > >Hello everybody > > > >Do you know why this simple trigger "hang-up" the database? > > > >CREATE TRIGGER TRANSACCION_INICIA > >ACTIVE ON TRANSACTION START > >POSITION 0 > >AS > >BEGIN > >Â Â > >Â Â IN AUTONOMOUS TRANSACTION DO BEGIN > >Â Â > >Â Â END > >Â Â > >END; > > > > > >Always when I put "IN AUTONOMOUS TRANSACTION" the database crash. Without > those words everything works fine. > > > >It is not possible to use autonomous transactions inside a database > trigger? > > From the forthcoming Firebird 2.5 Language Reference manual (yes, people, > it is coming!) > > Some Caveats > 1. The use of the IN AUTONOMOUS TRANSACTION DO statement in the database > event triggers related to transactions (TRANSACTION START, TRANSACTION > ROLLBACK, TRANSACTION COMMIT) may cause the autonomous transaction to enter > an infinite loop > > Helen > > >
