Hi,
I didn't make myself clear or
just nobody knows what i'm talking about or
everybody is ignoring me? : )

Valdir.

----- Original Message -----
From: "Valdir Stiebe Junior" <valdir@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, November 19, 2003 4:26 PM
Subject: [firebird-support] Recursive trigger and deadlock


> Hi,
> We're migrating from FB 1.0.3 to FB 1.5 RC7 both windows.
> I have two tables in a master detail relationship with cascade delete rule.
> On the detail table i have an after delete trigger that update a third table
> based on a field from the master table.
> So my detail table after delete trigger look like this...
> ....
> select field from master_table ... into some_variable
> if (some_variable ...) then
> update third table. ....
>
> With firebird 1.0 this trigger work ok while deleting details. But when
deleting
> the master, the select statement don't work (i've asked here a year ago about
> this, the problem was the cascade delete wich delete the master before
deleting
> the details rows). To workaround this i've created a trigger on the master
table
> before delete to delete the details with a delete from ....
>
> Now, with firebird 1.5 i'm getting a deadlock exception on the select
statement
> of the detail table after delete trigger. And disabling the master table
> trigger, i don't get a deadlock exception, but the select don't return any
> value.
>
> What is new (and that i missed) that is putting me in deadlock?
>
> TIA
> Valdir.