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] 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
>
>
>