On Fri, Aug 7, 2015 at 11:20 PM, Helen Borrie helebor@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

At 02:51 p.m. 8/08/2015, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [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